Auto filling a calendar based on dates inputted

custhasno · #5 07-30-2019, 04:17 AM

Quote:

Originally Posted by p45cal

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.

That is perfect, thank you very much.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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