|
|
#5
02-02-2022, 12:35 AM
|
|||
|
|||
Either:
a) Define your table on sheet Calendar as Table, and refer to it using Table formula syntax; or b) Define the range 'Due_Production_Date_Data' as Dynamic Range, like: Due_Production_Date_Data = OFFSET(Calendar!$A$1,1,,COUNT(Calendar!$A:$A),5) 
|
| Tags |
| vlookup, year change |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Word field last month not working within year change
|
eduzs | Word VBA | 4 | 07-25-2019 04:31 PM |
| How to search for a specific year from a table with year range? | Wii | Excel | 0 | 05-05-2015 12:40 PM |
| How to calculate a rolling year-to-date percentage by quarter as the year progresses | sleake | Excel Programming | 2 | 04-23-2015 11:51 AM |
|
Does anyone know if you can keep a calendar template full o info but change the year?
|
dartist | Word | 3 | 02-12-2014 01:28 AM |
| Creative Ways for a year-to-year comparison??? | ridonkulous5 | Excel | 1 | 03-23-2011 04:49 PM |
Windows 8 
Office 2016
Threaded Mode