SOLVED

FORMULA HELP

Copper Contributor

=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. 

2 Replies
best response confirmed by NCHARLES5409 (Copper Contributor)
Solution

@NCHARLES5409 

=IF(C9="","0",DATE(YEAR(C9),MONTH(C9)+24,DAY(C9)))

Maybe it is possible with an IF statement.

thanks so much that solved all my problems
1 best response

Accepted Solutions
best response confirmed by NCHARLES5409 (Copper Contributor)
Solution

@NCHARLES5409 

=IF(C9="","0",DATE(YEAR(C9),MONTH(C9)+24,DAY(C9)))

Maybe it is possible with an IF statement.

View solution in original post