If it is always 1 month difference use help cells with a formula like

=DATE(YEAR(A1),MONTH(A1)-1,DAY(A1))


Regards,

Peo Sjoblom

"JN" wrote:

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.