Formula to create yearly calendar of dates

[Estelle]

Hello,

I'm really new to Airtable and completely inexperienced with formula options.

I'm looking to set up a formula so I can easily create a list of dates for the calendar year. Right now I used # option but I think a formula is more in line with what I need...

Here is an example

[Ben_Young1]

Hey @Estelle! 

@TheTimeSavingCo resolved this for you in this thread.
Is there something we're missing?

[Estelle]

Using the #Value means I have to drag 1,2,3,4 and so forth endlessly for 365 days. As I currently understand it?

[Ben_Young1]

If you're creating records for unique days of a calendar year, your fundamental data object is a date.
With that in mind, why are you choosing this method over just using a date field as your primary field?

[Estelle]

When I drag the date field down it just duplicates it... it doesn't seem to add the following day.

It does (ex) May 11 2023, May 11 2023, May 11 2023 over 3 rows.

And not (ex) May 12 2023, May 13 2023, May 14 2023

[Ben_Young1 · Accepted solution]

You need to provide a sequence of initial data points, select all of them, then use the fill handle to continue the sequence.

You were doing this: