Formerly Best Training
© 2024 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
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel date calculations
Resolved · High Priority · Version 2003
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
|
Excel tip:Hide columns in an Excel 2010 WorksheetIf you don’t want part of the Excel worksheet to be visible or when you don’t want certain data to appear in print outs, then a simple solution is to temporarily hide a column or multiple columns. |
We'll call during UK business hours
Server loaded in 0.1 secs.