Excel stores each date as a serial number. This allows you to perform calculations that use dates. E.g. "How many days past due is this invoice?" Or "How many days remain in this billing cycle?"
I make use of a very handy Keyboard Shortcut in this video to reveal the serial number of any date - Ctrl + ~ (tilde)
I invite you to visit my website - www.thecompanyrocks.com - to view all of my Excel Training Videos.
Danny Rocks
The Company Rocks
thank man
SuperCorlal 1 year ago
@SuperCorlal
My pleasure - I am pleased that I was able to help you to understand how Excel calculates Dates. This can be quite confusing - giving you unexpected results.
Danny Rocks
The Company Rocks
DannyRocksExcels 1 year ago