Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
is there a formula to generate a calendar month date rather than . | Excel Worksheet Functions | |||
How to extract month number from month name | Excel Discussion (Misc queries) | |||
Calendar and info for that date | Excel Discussion (Misc queries) | |||
Sm Product a Calendar Month Range? | Excel Worksheet Functions | |||
Convert week number into calendar month? | Excel Worksheet Functions |