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.
|