Calculated column to flag Blackout dates on modern SharePoint List

Harry N Nomikos 1,266 Reputation points
2023-04-24T12:08:55.3166667+00:00

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

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

Accepted answer
  1. Ling Zhou_MSFT 15,560 Reputation points Microsoft Vendor
    2023-04-25T05:19:36.86+00:00

    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