Calculated Date Given Month and Day

Copper Contributor

I set up a birthday list using some guidance from a Youtube video that has since been deleted, and I'm hoping for some help. Right now, I have a column that is calculating 2023 birthdays based on the month and day column. I am wanting to update this for 2024, but I don't know what formula to use for the new column.

marissa_horn_1-1702333175507.png

 

I appreciate any help as this is all new to me!

2 Replies

@marissa_horn your calculated column just needs to have the following formula:
=Month&"/"&Day&"/"&"2024"

In my example the calculated column is calcBirthday:

calcBirthday.png

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP (and classic 1967 Morris Traveller driver)

@Rob_Elliott Thank you so much!