DAY
DAY(date)
The day of the month of a date, from 1 to 31, such as the day a task finishes on. It is the day of the month, not the day of the week, and not a count of days.
Arguments
| Argument | What to give it |
|---|---|
| date | A date, like [Finish date]. Blank gives blank. |
Examples
Formula=DAY([Finish date])
The day of the month the task finishes on.
Formula=DAY([Finish date]) > 25
TRUE for tasks finishing in the last days of a month, close to a monthly progress cut-off.
Formula=DAY(EOMONTH([Start date], 0))
How many days the month the task starts in has.