Show Blank Instead of 101900 in Excel | Don't Show 1900 on Blank Date | Leave Blank If No Date

[@denisegreen4592]

Thanks Chester! Excellent delivery and "translating" a formula into words to explain its function.

[@mbrandau]

Beautiful. I needed a solution to =DAYS360 when the end date was blank and your =IF function works perfectly. Thank you.

[@user-eb1xv1md5o]

Thanks Chester. I didn't realize excel was actually putting a '0' in the background. Could help me get rid of my problem right up front.

[@mrgooseegg]

Chester, you're amazing.I been trying to solve this issue with formulas :/ I didn't know it's that much simple. Thank you

[@mohammedmohsin8269]

Was searching for that If formula. Thanks a lot

[@deepakg1632]

Incredibly helpful! Many thanks.

[@ramoncincuneguicarrobe]

Just I was looking for 😀😀

[@JavedIqbal777]

THANKS A LOT BRO

[@mieczyslawm7093]

You really helped a lot but instead "" I have to use 0..
I'm counting days in stock up till today to know for how many days charge the customer, but the empty cells excel counts like 1900.
I simply avoided that with this formula =IF(A2=0;0;(I2-A2))
"A" is a column with a date of unloading and column "I" currently date done automatically.
Thanks.

[@swsafg]

Thank you

[@taboularaza1]

Cool. But it does not change how conditional formatting still considers BLANKS as LESS THAN YESTERDAY (or

[@alexanderbaranov5418]

Thanks, useful

[@lodwigwales]

Great video, I have the today+90 formula, it now returns (=90. How can I get it to zero please?

[@kiranbarru1918]

Sir very nice video, i have doubt sir can you plse clear my doubt. Can we add vlookup formula for this formula.Plse give reply sir

[@ChesterTugwell]

ruclips.net/video/Dit7Px2I8KE/видео.html

[@kiranbarru1918]

Sir very nice video, i have doubt sir can you plse clear my doubt. Can we add vlookup formula for this formula.Plse give reply sir.I am using MS OFFICE 2007

[@ChesterTugwell]

ruclips.net/video/Dit7Px2I8KE/видео.html