Forum Discussion

MVCuser's avatar
MVCuser
Brass Contributor
Sep 28, 2023

Add Date and Month columns in SharePoint List

Hi.

I have a sharepoint list where

Column 1) Last Review (is a date)

Column 2) Revision Period (is a number of Months)

i need to create column 3 to add 1 + 2.

when i tried to add them, it counts column 2 as number of days and i get something like this

Latest Review dateRevision Period (m)Next review date
01/09/2023203/09/2023

(note the format is dd/mm/YYYY)

 

what i want to get is Next Review date 03/11/2023

 

thanks

 

 

 

admin
Lists
SharePoint Online
  • LeonPavesic's avatar
    LeonPavesic
    Sep 29, 2023

    Hi MVCuser,

    To add Date and Month columns in SharePoint List, you can use a calculated column.

    Steps:

    1. Go to the SharePoint list where you want to add the new columns.
    2. Click on the + button and select More columns.
    3. Select Calculated as the column type.
    4. Enter a name for the column and a formula in the Formula field.
    5. For the Date column, use the following formula:

     

    =DATE(YEAR([Last Review]), MONTH([Last Review]) + [Revision Period (m)], DAY([Last Review]))​

     

    1. For the Month column, use the following formula:

     

    =MONTH([Next Review Date])​

     

    1. Click OK to save the columns.

    The new columns will be added to the list and will be populated with the calculated values.


    For Example

    Last Review Date Revision Period (m) Next Review Date Date Month
    01/09/2023203/11/202303/11/202311


    Please click Mark as Best Response & Like if my post helped you to solve your issue.
    This will help others to find the correct solution easily. It also closes the item.


    If the post was useful in other ways, please consider giving it Like.


    Kindest regards,


    Leon Pavesic
    (LinkedIn)

  • LeonPavesic's avatar
    LeonPavesic
    Silver Contributor
    Sep 29, 2023

    Hi MVCuser,

    To add Date and Month columns in SharePoint List, you can use a calculated column.

    Steps:

    1. Go to the SharePoint list where you want to add the new columns.
    2. Click on the + button and select More columns.
    3. Select Calculated as the column type.
    4. Enter a name for the column and a formula in the Formula field.
    5. For the Date column, use the following formula:

     

    =DATE(YEAR([Last Review]), MONTH([Last Review]) + [Revision Period (m)], DAY([Last Review]))​

     

    1. For the Month column, use the following formula:

     

    =MONTH([Next Review Date])​

     

    1. Click OK to save the columns.

    The new columns will be added to the list and will be populated with the calculated values.


    For Example

    Last Review Date Revision Period (m) Next Review Date Date Month
    01/09/2023203/11/202303/11/202311


    Please click Mark as Best Response & Like if my post helped you to solve your issue.
    This will help others to find the correct solution easily. It also closes the item.


    If the post was useful in other ways, please consider giving it Like.


    Kindest regards,


    Leon Pavesic
    (LinkedIn)

Resources