Formular to state number of days between two dates

M

ManFromBavaria

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Hi, this is hopefully an easy one for you smart guys out there.
How can I find the number of days between two dates, i.e.:
1st Date stated: 11/30/09 (30 nov 2010)
2nd Date stated: 01/06/10
Which formular to figure out the number of days between those two dates?
Thanks so much and greetings from Germany.
 
C

CyberTaz

Much simpler than you think :) Just subtract the cell containing the older
date from the cell containing the later date, format the cell containing the
formula as GENERAL or as NUMBER with no decimal places.

First date in A1
Second date in A2
Formula in A3: =A2-A1

HTH |:>)
Bob Jones
[MVP] Office:Mac
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

number of months and days between two dates without approximation 3
DAYS360 5
Days between two dates? 1
number of Full Months between dates & partial Days calculation 1
Count the highest number of days without “errors” 2
How can I use dates in a formula? 1
Business Days Between Two Dates? 4
Count specific days in between dates 2

Top