Auto Fill Date every 30 Days

Tony Barthelemy

Good Day All:

Is there a way to Auto-fill dates? For example: 

04/30/18

05/31/18

06/29/18

Thanks 

Mike Wilday

You could create the first date in the row... then in the 2nd row add this formula in the date column =[date column name]1 + 30

That will calculate your 2nd date, then you can drag down the bottom-right corner to populate the rest of the dates.   

Do note that if that first date disappears or changes it will affect the rest of the dates. 

Tony Barthelemy

Got it, Thanks!

Mike Wilday

You're welcome! Glad I could assist.