Forum Discussion

marissa_horn's avatar
marissa_horn
Copper Contributor
Dec 11, 2023

Calculated Date Given Month and Day

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.

 

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

SharePoint Online
  • Rob_Elliott's avatar
    Rob_Elliott
    Bronze Contributor
    Dec 12, 2023

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

    In my example the calculated column is calcBirthday:

     

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

Share

Resources