Month name headings

  • Thread starter Thread starter Al
  • Start date Start date
A

Al

I want to place headings on a report that gives the next 6
months (by name, March , April, May, etc) that is based on
todays date. The first column is always the month that
the report is run in.

Is there a formula I can use?

Thanks
Al
 
Well you could use the DateAdd function and format function

For instance the next month's name would be
=Format(DateAdd("m",1,YourFirstColumnDate),"mmmm")
 
John,
What if I do not have a date in the field, It is not a
date field, but I want the headings to have the month name.
 
Try text boxes with control sources like:
=Format(DateAdd("m",0,Date()),"mmmm")
=Format(DateAdd("m",1,Date()),"mmmm")
=Format(DateAdd("m",2,Date()),"mmmm")
...
 
Back
Top