Forum Discussion
Solved
Blank Cell Showing January 0, 1900
Good Day! Try as I might I cannot find a solution to this problem. Please see the attached pic. I am using Excel Online and have a formula to add 6 months to the displayed date. But when the ...
=IF(C4="","",EDATE(C4,B4))))
With this formula in column A you can return an empty cell in column A if column C is empty.
=IF(C4="","",EDATE(C4,B4))))
With this formula in column A you can return an empty cell in column A if column C is empty.
- Thank You!
That worked... sort of...
I ended up getting a failed formula until I tried: =IF(C4="","",EDATE(C4,B4))
Basically I just put 2 brackets at the end instead of 4.
