Forum Discussion
Solved
Calculate a month number in a separate column
Hello everyone,
I have a coumn "Storage reseption date" in a sharepoint list and I want to have a separate column (text or number) with a month number in it: if i have 03/12/2022 reception date, I need only 03 in a new column.
I tried to go through =TEXT(MONTH[Storage reception date]), but I receive a wrong syntax error.
Can someone help with this if it's possible?
JaneUser =TEXT([Storage reception date],"mm")
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
JaneUser =TEXT([Storage reception date],"mm")
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
You can try following formula which should work in both the case i.e. When Date is there or date is empty=IF(ISBLANK([Storage reseption date]),"",MONTH([Storage reseption date]))Hope it will helpful to you and if so then Please mark my response as Best Response & Like to help others in this community
