Return the first day of the previous month


 A
1=TODAY() = Sunday 19 May 2024
2=NOW() = Sunday 19 May 2024 13:52:44
3=DATE(YEAR(TODAY()), MONTH(TODAY())-1, 1) = 01/04/2024

Built-in Functions

DATE - The date as a date serial number given a year, month, day.
NOW - The date serial number of the current system date and time.


Related Formulas

Return the first day of the current month
Return the first day of the next month
Return the last day of the current month
Return the last day of the previous month
Return the last day of the next month


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top