In SharePoint 2013 (on-premise), we have a list that our HR department uses to keep MVR documentation up to date. Â Right now the form has two dates that they manually calculate for each entry in the list… one is 6 month intervals and the other is 12 month intervals.
I want to modify the list so that based on the date the form is entered, the date is calculated for HR. Â So in the one column (for this discussion will call it Column1) the date would be 6 months plus the Entered Date and for the Column2 the date would be calculated as the 12 months plus the Entered Date.
Now here’s the part I’m concerned about, each time there’s an update from HR on a list item, the columns would need to recalculate. Â I know how to create the calculated columns, what I do not know is will COlumns 1 and 2 recalculate if the Entered Date changes (not the default Created date, but a column that we’ve called Entered Date)
If there’s a better way to do this, I would appreciate your input. Â
Hi
Yes , calculated col1 and col2 will be recalucalted based on new entered date on each update.