Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Formula to create yearly calendar of dates

Topic Labels: Formulas
Solved
Jump to Solution
2820 5
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
Ben_Young1
11 - Venus
11 - Venus

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