Computing.Net > Forums > Office Software > subtracting dates in exce;l

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Click here to start participating now! Also, check out the New User Guide.

subtracting dates in exce;l

Reply to Message Icon

Name: remdog99
Date: August 25, 2006 at 12:46:20 Pacific
OS: windows xp pro sp2
CPU/Ram: P3/288
Product: ibm
Comment:

When I use the '=A3-A2' to find the # of days between 2 dates, I get a result like '02/01/1900'---what am i doing wrong?




Response Number 1
Name: dtech10
Date: August 25, 2006 at 13:00:31 Pacific
+1
Reply:

Hi remdog99
format the cell as a general number.



Response Number 2
Name: Michael J (by mjdamato)
Date: August 26, 2006 at 06:41:40 Pacific
+1
Reply:

That will work, but the more appropriate method is like this:

=DATEDIF(A1,A2,"d")

Michael J



Response Number 3
Name: Jennifer SUMN
Date: August 28, 2006 at 05:59:23 Pacific
+1
Reply:

I use this one:

=DAYS360(A1,A2) with the cell containing the formula formatted as a number

Life is more painless for those who are brainless.



Reply to Message Icon

Related Posts

See More


Can't install SP3 on Offi... Easy inset picture in PPT



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Google Ads



Results for: subtracting dates in exce;l

Subtracting Dates in Excel www.computing.net/answers/office/subtracting-dates-in-excel/8894.html

Formating dates in excel www.computing.net/answers/office/formating-dates-in-excel/8732.html

Date in Excel www.computing.net/answers/office/date-in-excel/541.html