Current month and the next two

M

menken.john

How can I get the top of my Report to display the current month and the next two columns to show the next two months.
In other words if I open the report today the top of column D should read "May" and the tops of E and F should say "June" and "July" respectively.
If I open the report in October, D should say October, E should say November and F should say December. I entered =Now() and formatted as a month but I can figure out how to do the columns to the right. I know that adding 30 or 31 cannot be the answer.
Thank you.
 
M

Michael Bednarek

How can I get the top of my Report to display the current month and the next two columns to show the next two months.
In other words if I open the report today the top of column D should read "May" and the tops of E and F should say "June" and "July" respectively.
If I open the report in October, D should say October, E should say November and F should say December. I entered =Now() and formatted as a month but I can figure out how to do the columns to the right. I know that adding 30 or 31 cannot be the answer.
Thank you.
Click to expand...

Have a look at the function EDATE().
D1: =NOW()
E1: =EDATE(D1,1)
F1: =EDATE(E1,1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro for comparing columns and highlighting matching/differences 14
Mapping strings to integers 5
days of the current month 2
For ... next 7
6 month time bracket in report header 2
Count the Number of Weekdays by Month 3
Formula to fill cells based on Date of Arrival and Date of Departure 1
Sort pivot table field (droplist) by month or original data 1

Top