Calculated column to flag Blackout dates on modern SharePoint List

Question

Hi Team Can I please look at having a calculated column formula for my modern SharePoint List that will return a value of "2023 EOFY Blackout Date" when the Go Live Date value falls between 5/06/2023-30/06/2023. If the Go Live Date falls outside this date range, I want it to return a blank value. Cheers
Harry

Answer 1

Hi @Harry N Nomikos ,

Here is the formula of calculated column:

=IF(AND(TestedDate>=DATEVALUE("6/5/2023"),TestedDate<=DATEVALUE("6/30/2023")),"2023 EOFY Blackout Date","")

TestedDate is the name of the date and time column, In the above formula you need to replace the name with the name of your date column.

Fill Formula to the position as shown (Result is the name of the calculated column).

The demonstration results are as follows. In addition, in the list of SharePoint, the date format is month/day/year.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".