Calculated column to flag Blackout dates on modern SharePoint List

Harry N Nomikos 1,246 Reputation points

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

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,244 questions
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,806 questions
{count} votes

Accepted answer
  1. Ling Zhou_MSFT 13,905 Reputation points Microsoft Vendor

    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). 1

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

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

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful