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 displayed date happens to be blank then the resulting value shows up as January 0, 1900. IS there a way to avoid this? I've noticed some of the solutions I found online are limited because I'm using Excel Online.
=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.
2 Replies
=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.
