I have following formula.
need addition if B3 is blank than blank, not sure how, please help.
The formula cell is L3
Control Sheet! AC4 = Apr
=IF(0+TEXT(1&B3,"m")<=0+TEXT(1&'Control Sheet'!$AC$4,"m"),INDEX({31;59;90;120;151;181;212;243;273;304;334;365},TEXT(1&'Control Sheet'!$AC$4,"m")),0) |
need addition if B3 is blank than blank, not sure how, please help.
The formula cell is L3
Control Sheet! AC4 = Apr