View Single Post
 
Old 01-14-2019, 12:57 PM
cmersho cmersho is offline Windows 10 Office 2016
Novice
 
Join Date: Jan 2019
Location: Indiana
Posts: 1
cmersho is on a distinguished road
Wink Auto insert dates for a complete year

Hello, Using office 365. I have a form in excel that contains 14 date fields. Currently
I have to go into the fields and change the dates manually than print the form for each month. This process takes a long time to do the entire year. Is it possible to add a start date like 1/1/19 on another sheet, then auto populate the date fields on my form and print until it reaches 365 days? Or do I need to make 24 sheets and have them auto add the dates? Either way can someone tell me how? I'm quit new to using formulas and excel, so any help would be appreciated. Thanks in advance to all.
Reply With Quote