| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fiscal Year in date field
Thank you very much. That was very helpful.
there are three great answers here and I'll try them all. keith "vezerid" wrote: Keith, there are several ways to tackle this. One way is to put the number 2002 in a cell, say K1. Then let us say you start with your fiscal years in A3. ="FY "&$K$1+(ROW()-ROW($A$3))&" - "&$K$1+(ROW()-ROW($A$3))+1 Does this help? Kostis Vezerides |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ho to Delete "Ghost" Pivot Tables | Excel Discussion (Misc queries) | |||
| Capturing a date field once only | Excel Worksheet Functions | |||
| Year-to-date year to date formula | Excel Worksheet Functions | |||
| How to Join/concatenate a date field with a time field in Excel? | Excel Discussion (Misc queries) | |||
| How to get only the year in the date format in Access | New Users to Excel | |||
Hybrid Mode
