View Single Post
  #1   Report Post  
JN
 
Posts: n/a
Default Accounting Month vs. Calendar Month

Hi,

I want to know if I can get Excel to show the Accounting Month instead of
calendar month by providing both start and end date of the Accounting Month.

This is the problem I have:
I have a date, for example, April 2, 2004. This is considered April, but in
fact, it is March per the Accounting Month. How can I make Excel to show
March instead of April? I have hundreds of lines and don't want to keep
looking at the 2004 calendar to find out what Accounting Month it belongs to.

Please help.