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! :slightly_smiling_face: 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. :slightly_smiling_face:

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!

Your post reminded me how in Marathi culture birthdays are often anticipated well in advance, with families preparing rituals and blessings ahead of time. I recently adapted a marathi wishes for a family and it felt sincere. Even setting reminders for next year can ensure those cultural touches never get missed.

Terms & ConditionsAccessibility statement