Skip to main content

Auto generate dates in a column

  • December 17, 2020
  • 1 reply
  • 15 views

Hello, I’m trying to create a social media calendar.
I want to auto-add every day of the year into a column.
Is there a way?

This topic has been closed for replies.

1 reply

Forum|alt.badge.img+4
  • Participating Frequently
  • January 1, 2021

I am not the person to really be offering advice because I’m sure there is an easier way, but I came up with a workaround to get you by until someone offers the right way. I created a count column and a start date column that contained the date that I wanted (in your case it’d 1/1). Then created a formula column that added the start date and count columns. (DATETIME_FORMAT(DATEADD({Start Date},Count-1,‘DAYS’),‘MM/DD/YYYY’). I’m in this room because I was searching up a way to format the outcome as a date so I can view it in a calendar. Hope this gives you a starting point.