|
|
#4
07-28-2019, 10:35 AM
|
||||
|
||||
In the attached, cells C9:C20 contain actual dates (the firsts of the month) and so also contain year information. You can revert to showing just the month as I have done in cell C15.
AZ9:AZ20 contain new values for a vlookup, but I was being lazy and should have used index/match on your other table at AM9:AN18. There are formulae in the range D9:AH20 (one formula copied down and across). If there are duplicate dates only the uppermost will show. 
|
| Tags |
| auto fill, calendar, date |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| is sit possible to auto populate a cell based on dates | wheddingsjr | Excel | 6 | 11-27-2017 11:21 AM |
| Assemble a destination_range for auto-filling a formula | Officer_Bierschnitt | Excel Programming | 2 | 11-20-2015 07:15 AM |
 Auto populating dates on timesheet for week from one inputted date
|
ohi | Word VBA | 3 | 12-04-2014 12:11 PM |
|
Excel to auto populate dates based on start and end
|
patidallas22 | Excel Programming | 9 | 04-21-2014 03:14 PM |
| How do I stop filling of dates | Brent | Word | 0 | 10-24-2011 11:44 AM |
Windows 10 
Office 2016
Threaded Mode