We are on SharePoint 2013 externally and Office 365. I am trying to make a calculated column to filter a list on specific dates but it keeps error. Is it possible to calculate on dates such as Between 01/04/2016 AND 31/08/2016 ?

  • are you want to filter list by date range? – SP Developer Sep 13 '16 at 7:41
  • 2
    Do you want to filter the list? Also what is formula that you are using and getting error – Gaurravs Sep 13 '16 at 7:48
  • Intan As above I want to make a formula in a column to result in yes or no using any actual dates but not using today. yes to filtering on a date range – Ian H Sep 13 '16 at 8:27
  • Gaurravs I put the formula there in the question – Ian H Sep 13 '16 at 8:28

If you want to filter some elements of the list, then You can create a view with some filters, that are based on a date.

This article can also be helpful`

How to use Today and Me in Calculated column

  • Marcin O I wish to use actual dates in a calculated column because I can then change the dates to suit – Ian H Sep 13 '16 at 8:26

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.