I have a library with a column 'Expiry Date'. I wish to create an additional column to advise the user if a particular entry needs to be reviewed.

The parameters for this is if the 'Expiry Date' is 14 days or less from Todays' date.

In the filter I understand you can't use [Today] and have tried the workarounds but without much luck.

I'm fairly new to calculated columns so any assistance would be greatly appreciated.


Calculated formula should be like:

=IF([ExpiryDate]-14 <= NOW(),"Expired","Not Expired")
  • Many thanks Ronak. I have tried the above formula and although works in principle, still not quite what I was after. i.e. I have an Expiry Date of 28th Nov 2016 which is saying Not Expired which is correct, but I would only wish to show items in the list with an Expiry Date of 14 days or less from current date. Any ideas on how to do this? Oct 6 '16 at 7:27
  • If you want to show only those items which are expired then create list view & filter with 'CalculatedColumn1' is equal to 'Expired' Oct 6 '16 at 7:36
  • So if I have an Expiry Date of say 31 Dec 2016 showing. How do I go about ensuring in that list only Todays Date (i.e. 06th October) up to 20th October is only refelcting. i.e. NOW()+14. Oct 6 '16 at 11:54
  • means ? have you created view with filter on calculated column ? ,.. then only expired items will be shown.. Oct 6 '16 at 12:01
  • 1
    Remember: Today and Now in Calculated Formulas do NOT auto update: sharepoint.stackexchange.com/questions/151144/… Oct 17 '16 at 9:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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