SharePoint Online.

Date Column A - Date when the value changed to X, 
Date Column B - Date when the value changed to Y, 

How to create a calculated

Date Column C = Recent Modification or latest change in Column A Or Column B?

3 Answers 3


Column C formula is

=IF([ColumnA]>[ColumnB], [ColumnA], [ColumnB])

I think this maybe what you are looking for but we completely need more information like "What you are really looking to accomplish;"

Try... =IF([Modified]>[ColumnA], [Modified], IF([ColumnA]>[ColumnB], [ColumnA], [ColumnB]))


SharePoint does not record when a COLUMN value changed; if you need that you must create a Workflow and do the administration yourself

If you mean you want the maximum value of the 3 columns:

DateA or DateB or Modified (SharePoints last registered anything-in-the-ITEM changed)

it is:

=MAX( [DateA] , [DateB] , [Modified] )


Not the answer you're looking for? Browse other questions tagged or ask your own question.