gpt-3.5-turbo-0613· OpenAI
WildChat-4.8M (AI2)
Please write a formula to do this: If A3 is not blank and If DAY(A3) value is NOT…
- 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
- Assistant
=IF(AND(A3<>"", OR(DAY(A3)<G2, DAY(A3)>H2)), "X", "")