SOLVED

Add Date and Month columns in SharePoint List

Brass Contributor

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

 

 

 

1 Reply
best response confirmed by MVCuser (Brass Contributor)
Solution

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)

1 best response

Accepted Solutions
best response confirmed by MVCuser (Brass Contributor)
Solution

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)

View solution in original post