Skip to content
TheChatArchiveThe Chat Archive
gpt-3.5-turbo-0613· OpenAIAi2 WildChat-4.8M (AI2)

Please write a formula to do this: If A3 is not blank and If DAY(A3) value is NOT…

  1. User

    Please write a formula to do this: If A3 is not blank and If DAY(A3) value is NOT between the values in G2 and H2 Then write "X" to cell

  2. Assistant

    =IF(AND(A3<>"", OR(DAY(A3)<G2, DAY(A3)>H2)), "X", "")