Skip to main content

I’m looking for a way to have a calendar view of upcoming birthdays. I can use the formula below to show the CURRENT year’s birthdays but I also want the calendar to show NEXT year’s birthdays so that in December 2020, I could look at the Calendar and see the January 2021 birthdays. I know I need a separate field and have the calendar us both fields but I can’t figure out how to add 1 year to the formula below for the second field.,


DATETIME_PARSE(

DATETIME_FORMAT(

BirthDate,

‘MMMM D’

)&

’ '&

YEAR(

TODAY()

),

‘MMMM D YYYY’

)

Let’s say that your current formula field is called “Current Birthday”.

Then your new field would be a formula field that looks like this:

DATEADD({Current Birthday}, 1, 'year')

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld


Thanks Scott, that worked perfectly.


Glad I could help! 🙂 If you don’t mind, could you please mark my comment above as the solution to your question? This will help other people who have a similar question in the future. 🙂


Done! Thanks again.Scott.


That sounds like a great way to stay ahead with birthday reminders! If you're also looking for unique and heartfelt birthday messages in Marathi. It has a fantastic collection of wishes to make birthdays extra special!


Reply