This video contains everything you need to know to have confidence with Excel Dates. if you sometimes find dates turn into long numbers or you have never tried to find the the difference between two sets of dates then this video is for you.
The video initially talks about how Excel handles Dates internally and why it stores them as numbers. It then goes on to tell you how to write equations to find the difference between two dates.
On the way it also introduces you the ### problem in Excel and the shortcut key for entering today’s date into a cell and how important absolute references are.
Slightly slower than our usual videos but it is very clearly demonstrated.
If you have enjoyed this video please share it or like it using the buttons above or leave comments for others in the box below