Forum Discussion
sabriakter
Jan 28, 2021Copper Contributor
Can someone explain the meaning of this formula?
=IF($B$11>DATE(103,1,1),IF($B$11<DATE(103,12,31),MAX(DATE(103,1,1),$B$11),""),IF($B$11<DATE(103,1,1),DATE(103,1,1),""))
adversi
Jan 28, 2021Iron Contributor
sabriakter This is a better way of reviewing the formula and the Nested If statement:
=IF($B$11>DATE(103,1,1),
IF($B$11<DATE(103,12,31),MAX(DATE(103,1,1),$B$11),""),
IF($B$11<DATE(103,1,1),DATE(103,1,1),""))
The first line is checking if cell B11 is after 1/1/2003
If TRUE, it checks if B11 is before 12/1/2003
if TRUE, it will return the date in B11
if FALSE, it will return BLANK
the last line is the FALSE statement if B11 is after 1/1/2003:
The IF statement reviews if B11 is before 1/1/2003,
if TRUE, it returns 1/1/2003
if FALSE, it returns BLANK
- sabriakterJan 28, 2021Copper Contributor
adversihow did you translate the (103,1,1) to 1,1,2003?