Hi crew - new here! I hope this isn’t a silly question. I’m building a social media calendar which requires two rows for each day of the month (one for a FB post and one for an Instagram post) and each row has a date column.
So it should be
What I’m struggling to figure out is how to…
- generate consecutive dates for each new row and
- do so in a pattern of 2’s (i.e., 2 rows for the 1st of the month with one for each social channel (FB, IG))
I can’t for the life of me figure out how to even populate new rows with consecutive dates to achieve the effect of how you can click and drag down in Excel to apply the date pattern. I’ve tried every date related formula as well as creating a button to create a new row with the date + 1.
Any help would be much appreciated!!