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.