Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Formula to create yearly calendar of dates

Solved
Jump to Solution
2370 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Estelle
5 - Automation Enthusiast
5 - Automation Enthusiast

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

Estelle_0-1679583596558.png

 

1 Solution

Accepted Solutions

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

2023-03-23_14-16-17.gif

You were doing this:

2023-03-23_14-18-28.gif

See Solution in Thread

5 Replies 5

Hey @Estelle

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

Estelle
5 - Automation Enthusiast
5 - Automation Enthusiast

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

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
5 - Automation Enthusiast
5 - Automation Enthusiast

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

Estelle_0-1679597284734.png

 

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

2023-03-23_14-16-17.gif

You were doing this:

2023-03-23_14-18-28.gif