How do I make a column blank until data is entered? 1/14/1900 and 44028

[juno612]

Today's date + 14 days as a "payment due day", then next column is "number of day" overdue.

How do I make a column blank on column E and 0 on column F?

See attachment for sample, Thanks

[Pepe Le Mokko]

In E3 =IF(D3="","",D3+14)
In F3 =IF(E3="","",TODAY()-E3)
Similar formulas for the other columns

and pull both down
Your column F is formatted as text. Format as General Hit F2 and Enter

[bebo021999]

E2:
=IF(D3="","",D3+14)
F2:
=iferror(TODAY()-E3,0)

[Pepe Le Mokko]

BTW your sheet is way too heavy for so little data
See https://www.techrepublic.com/blog/mi...orkbook-bloat/ on how to solve this

And, IMO be aware that IFERROR hides ALL errors which might not be what you want

[juno612]

Ok, thanks everyone

[juno612]

E2:
=IF(D3="","",D3+14)
F2:
=iferror(TODAY()-E3,0)

This will ended with the number set 44058

[juno612]

In E3 =IF(D3="","",D3+14)
In F3 =IF(E3="","",TODAY()-E3)
Similar formulas for the other columns

and pull both down
Your column F is formatted as text. Format as General Hit F2 and Enter

When I am using this one, the cell is empty which is great. When I entered the Date on D column, it shown -14. How can I make it 0 instead of showing negative number. Thanks

[Pepe Le Mokko]

This will ended with the number set 44058

Format the cell as date

[Pepe Le Mokko]

When I am using this one, the cell is empty which is great. When I entered the Date on D column, it shown -14. How can I make it 0 instead of showing negative number. Thanks

I don't understand ( again a small sheet example would do wonders) but perhaps IF(OR(E3>today(),E3=""),"",TODAY()-E3)