SOLVED

Blank Cell Showing January 0, 1900

Copper Contributor

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.

 

 

Cell Showing January 0, 1900.PNG

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

@GasDetect 

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

edate.png 

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.
1 best response

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

@GasDetect 

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

edate.png 

View solution in original post