How to make Date cell show = 0, not 1/0/1900?

[jwindholz2725]

I'm trying to make a custom spreadsheet from existing data to show due dates but the issue is if there is currently no due date the cell has a zero value and shows 1/0/1900. For simplicity A1 would be where I want to show due dates and B1 is the existing data (A1=B1). So if B1 is blank I get 1/0/1900 in A1. I've changed A1 to a General cell format which works, but then I run into an issue with actual dates. For example 1/15/2021 will show as 44211. I'm thinking there is an IF formula that could solve but can't figure it out. Any help would be appreciated.

 

[mohadin]

See if this works for you

=IF(B1=0,"0",B1)

 

[Phuoc]

Format Cells => [>0]mm/dd/yyyy;General

 

[jwindholz2725]

Mohadin you are awesome, worked perfect!

 

[mohadin]

You are welcome
And thank you for the feedback
Be happy