Can someone explain the meaning of this formula?

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