Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

subtracting dates in exce;l

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?

+1

Reply:

Hi remdog99 format the cell as a general number.

+1

Reply:

That will work, but the more appropriate method is like this: =DATEDIF(A1,A2,"d") Michael J

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.

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.

Summary: Is there any way to disregard weekends and / or holidays when subtracting dates in Excel? ...

Summary: Actually, for your string you would need to use: =MID(A1,5,2)&"/"&RIGHT(A1,2)&"/"&(LEFT(A1,4)) With your string in A1, click on the cell where you want to see 03/14/2004 and paste in the formula. It c...

Summary: Ok, I have a spreadsheet with 500 rows and the first column has a date in it. The date comes up as 2003. It should be 2001. Is there a way to change all the cells at once from 2003 to 2001? Now ea...