Sharepoint doc list review date

[nqueen365]

Need help with review date calculated value -

Any advice on how to get this to work? I'm trying to have this auto-calculate to 6 months from modified by date. The formula I am trying does not seem to work.

[#2 · Accepted solution]

@nqueen365 Here you go!

=DATE(YEAR([Modified]),(MONTH([Modified])+6),DAY([Modified]))

[#3]

@nqueen365 This is a known limitation of SharePoint. You cannot refer another column values while setting Default value of a column in list.

In order to use the calculated formula, your "Review Date" column must be a calculated column (not Date and Time).

---

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.

[#4]

@ganeshsanap is correct- my bad! my solution will work in a calculated column but not as a default value.