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?
Auto generate dates in a column
This topic has been closed for replies.
+4I 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.