Default to End of Month
This calculated default value uses a SharePoint formula to pre-fill the field with the last day of the current month. Set as a calculated default value, it pre-fills the column when a new item is created, and users can still change it.
How It Works
- What it does: Pre-fills the date field with the last day of the current month whenever a new item is created.
- What you get: A new item opens with that month’s end date already filled in, and users can still change it.
- Good to know: It’s set once, at creation – it won’t shift if the month rolls over later, and there’s no message or block involved.
Common Use Cases
- Default billing or period-end date
- Month-end deadlines
- Reporting cut-offs
- Standard close dates
Details
- Formula Type: Calculated Default Value
- Formula Category: Dates & Time
Required Columns
| Display name | Column type |
|---|---|
| Date | Date and Time |
How to Apply the Formula
- Open the column settings (or create the column)
- Under Default value, choose the calculated value (formula) option
- Paste the formula below
- Save. New items will be pre-filled, and users can still change the value
Formula
=DATE(YEAR(TODAY()),MONTH(TODAY())+1,1)-1Common Questions About Default to End of Month Formula
What does this formula do?
Pre-fill month-end. It runs as a default value, pre-filling the column on new items.
Which columns do I need to set this up?
No other columns are required – the formula uses today’s date, the current user, or a constant, and applies to the column you set it on.
Will the default value update later?
No. It is calculated once when the item is created. After that it stays put unless someone changes it.
If LookBook 365 is code-free and out-of-the-box, why does this example use a formula?
A SharePoint formula is native, declarative configuration, not custom development. It only works with the item’s own fields and simple logic – it cannot run scripts, reach external services, or change other data, and nothing is deployed to your tenant. It keeps working through Microsoft updates. If you would rather not set this up yourself, this is exactly the kind of thing I configure for clients.
Default to End of Month Formula Example