Sep 28 2023
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
(note the format is dd/mm/YYYY)
what i want to get is Next Review date 03/11/2023
View best response
Sep 29 2023
To add Date and Month columns in SharePoint List, you can use a calculated column.
=DATE(YEAR([Last Review]), MONTH([Last Review]) + [Revision Period (m)], DAY([Last Review]))
=MONTH([Next Review Date])
The new columns will be added to the list and will be populated with the calculated values.
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.