I have created the following list (Timeframe) in SharePoint;
- Start Date
- End Date
Another column, [Is Current Timeframe], needs to be created that specifying whether or not the Timeframe item is the current timeframe. That is, if today's date falls between [Start Date] and [End Date], the new column should be populated with "Yes", otherwise "No".
if [today's date] is between [Start Date] and [End Date] then [Is Current Timeframe] = Yes else [Is Current Timeframe] = No
The formula I tried using returned an error, and was not correct;
=IF (AND([Today]>=[Start Date], [Today]<=[End Date]), "Yes", "No")
What am I doing wrong with the formula?
Also, what would be the best way to update [Is Current Timeframe] daily? That is, the value of [Is Current Timeframe] should be recalculated each day to make sure it is correct.