Solutions Through Learning
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel date calculations
Ishdev has attended:
Excel Intermediate course
Excel Advanced course
Hi, unfortunately i'm having a senior moment.
I have 2 cells (A1 & B1), both with dates following the mm/dd/yyyy convention. Now i need to know the number of days between the 2 dates given.
A simple calculation of =B1-A1 gives an answer of mm/dd/yyyy and not the number of days between those 2 dates.
Any ideas?
Thanks & Regards
Ish
1. At the end of the formula, add a + (plus) sign.
2. Type the letter N, and in parentheses, type your comment in quotation marks.
eg.
=CurrentAssets / CurrentLiabilities+ N("The formula returns Current Ratio")
TrustScore
4.9
/ 5
2394 reviews
Connect with us:
Call for assistance
We will call you back
Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.
