Thanks, Peo.
But the tricky part is that it isn't always 1 month behind. It can be a
couple days difference, or couple days ahead. For example, 2/28/04 is
considered March per Accounting Calendar I have. Any suggestions? Thanks.

This is a partial Accounting Calendar I have:

12/27/03-1/30/04 = Jan Accounting Month
1/31/04-2/27/04 = Feb Accounting Month
2/28/04 - 4/2/04 = March Accounting Month
4/3/04 - 4/30/04 = April Accounting Month

"Peo Sjoblom" wrote:

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.