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

[@AdamCanfield-r6z]

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.

[@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.

[@lenatay]

Thanks!

[@ChesterTugwell]

Many thanks

[@GPMAccountingthruGmail]

I have been loosing my mind with FILTER formula and date criteria that have no date! Hence the 1900. THANK YOU!

[@muhammadarif8006]

Excellent teaching Sir thanks 🇵🇰

[@mohammedmohsin8269]

Was searching for that If formula. Thanks a lot

[@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

[@thandoluhlendlovu6012]

This just saved my day, thank you mate.

[@deepakg1632]

Incredibly helpful! Many thanks.

[@hamzariazuddin424]

this is great. Anyway without a formula. Of having a blank cell display .......... when empty. I want it to be in date format also. so when there is nothing entered, it displays .......... or if there is a date inside it displays ddd dd mmm format

[@jo2Video]

Thank you worked perfect

[@lodwigwales]

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

[@ramoncincuneguicarrobe]

Just I was looking for 😀😀

[@taboularaza1]

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

[@JavedIqbal777]

THANKS A LOT BRO

[@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

[@swsafg]

Thank you

[@alexanderbaranov5418]

Thanks, useful