Date format
Solved/Closed
Related:
- Date format
- Excel date format dd.mm.yyyy - Guide
- Format factory - Download - Other
- Samsung format code - Guide
- Whatsapp date format - Guide
- How to format hp laptop - Guide
2 responses
yg_be
Posts
22698
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
April 18, 2024
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())