Mar 24 2022 01:18 PM
=DATE(YEAR(C9),MONTH(C9)+24,DAY(C9))
IM TRYING TO USE THIS FORMULA TO ADD 2 YEARS TO THE DATE IN C9 BUT IF C9 IS BLANK IT PUTS A DATE FROM 1901 IS THERE A WAY TO ADD A IFBLANK=0 TO THE FORUMLA? SUCH AS
=DATE(YEAR(C9),MONTH(C9)+24,DAY(C9))(IFBLANK(C9)("=0"))
IM NOT VERY GOOD WITH ELCEL ANY HELP IS VERY APPRECIATED.
Mar 24 2022 01:25 PM
Solution=IF(C9="","0",DATE(YEAR(C9),MONTH(C9)+24,DAY(C9)))
Maybe it is possible with an IF statement.
Mar 24 2022 01:25 PM
Solution=IF(C9="","0",DATE(YEAR(C9),MONTH(C9)+24,DAY(C9)))
Maybe it is possible with an IF statement.