Date format [Solved/Closed]

deakin1980 - Dec 14, 2016 at 08:56 AM - Latest reply:  deakin1980
- Dec 14, 2016 at 03:18 PM
Hello,

i am trying to create a report which will show me the first date and last date of the previous month. I need first date in one field and second in another.

Is there a formula i can use for this?

Thanks

See more 

2 replies

yg_be 5231 Posts Sunday June 8, 2008Registration dateContributorStatus April 20, 2018 Last seen - Updated by yg_be on 14/12/16 at 01:40 PM
0
Helpful
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())
0
Helpful
Your a star exactly what I was looking for. Finally can complete my macro :)