Forum Discussion

JaneUser's avatar
JaneUser
Copper Contributor
Mar 06, 2023
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, ...
  • RobElliott's avatar
    Mar 06, 2023

    JaneUser =TEXT([Storage reception date],"mm")

     

    Rob
    Los Gallardos
    Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

Resources