Report

Date format [Solved]

Ask a question deakin1980 - Last answered on Dec 14, 2016 at 03:18 PM by deakin1980
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 
Helpful
+0
moins plus
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())
Leave a comment
Helpful
+0
moins plus
Your a star exactly what I was looking for. Finally can complete my macro :)
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!