How does one determine what is Acct month. Is it that any month that does
not begin on a Monday is considered previous month for that week or what?


"JN" wrote in message
...
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.