Prev Previous Post   Next Post Next
  #1   Report Post  
James
 
Posts: n/a
Default Dates

I have two cells with a data in each cell. Is there a
formula that I could put in a third cell that determines
the number of days between the two dates?

i.e.

A1 = 4 March 2004
A2 = 28 December 2004
A3 = formula that subtracts A2 from A1 to get the number
of days between these two dates.

Many thanks!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Plotting Dates GGoetz Excel Worksheet Functions 1 March 30th 05 10:08 AM
Excel not recognizing Dates properly. Dan Excel Discussion (Misc queries) 1 March 23rd 05 07:19 PM
How do I get Excell to sort dates that range from 1800 to 1900's Smith295 New Users to Excel 1 February 22nd 05 06:20 PM
Formating Dates for production schedule dpl7579 Excel Discussion (Misc queries) 1 January 11th 05 08:43 PM
due dates Niki New Users to Excel 4 January 10th 05 04:11 PM


All times are GMT +1. The time now is 02:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"