| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change Year Date In A Formula Throughout The Spreadsheet
I am using the formula =COUNTIF('Jan-06'!$D$3:$D$500,"Sales"). We copy the
data down within the same spreadsheet to create one for the new year. The Jan-06 is based on the tab name, therefore when the year changes to 2007 the added new tab will be Jan-07. This is used for all 12 months in 12 columns with the "Sales" changing for each item that needs counting. Is there a way to create a formula that when the year is changed in the first formula in Column B5, the year in every formula in the spreadsheet is changed within that section only? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change year date | Excel Worksheet Functions | |||
| Vacation Accrual Formula | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Date formula: return Quarter and Fiscal Year of a date | Excel Discussion (Misc queries) | |||
| Formula to get a day of the year from a date | Excel Discussion (Misc queries) | |||
Threaded Mode
