Date format
Solved/Closed
Related:
- Date format
- Excel date format dd.mm.yyyy - Guide
- Format factory - Download - Other
- Kingston format utility - Download - Storage
- Swissknife format - Download - Storage
- Marksheet format in excel - Guide
2 responses
yg_be
Posts
23419
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
January 10, 2025
5
Updated by yg_be on 14/12/16 at 01:40 PM
Updated by yg_be on 14/12/16 at 01:40 PM
If your date is in A,
First day of the previous month: =DATE(YEAR(A1);MONTH(A1)-1;1)
Last day of the previous month: =A1-DAY(A1)
If your reference day is now,
First day of the previous month: =DATE(YEAR(TODAY());MONTH(TODAY())-1;1)
Last day of the previous month: =TODAY()-DAY(TODAY())
First day of the previous month: =DATE(YEAR(A1);MONTH(A1)-1;1)
Last day of the previous month: =A1-DAY(A1)
If your reference day is now,
First day of the previous month: =DATE(YEAR(TODAY());MONTH(TODAY())-1;1)
Last day of the previous month: =TODAY()-DAY(TODAY())