|
|
|
|
#1
05-06-2016, 09:07 AM
|
|||
|
|||
In the following I work with the format dd-mm-yyyy
With 02-09-2015 in A1 and 05-05-2016 in A2 then in A3 try to enter =A2-A1 which I think returns 02-09-1900. Now try to format cell A3 General. and you should get the number 246 which is the number of days from 02-09-2015 to 05-05-2016. 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Just Starting Out, Pretty Basic Question | fishhead202 | Word VBA | 3 | 10-31-2014 05:56 PM |
| A simple math question | markg2 | Excel | 6 | 03-01-2014 11:10 AM |
| Forms: A very basic question/request | Coli | Outlook | 0 | 08-24-2011 11:14 AM |
| A basic question I'm sure. | talosian | PowerPoint | 0 | 04-21-2011 05:43 AM |
| Auto-updating basic math functions & cross-referencing tables | FranklinBluth | Word Tables | 13 | 11-19-2009 10:26 AM |
A basic date math/data view question
Windows 10 
Office 2016
Hybrid Mode