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?

Reply:

Hi remdog99 format the cell as a general number.

0

Reply:

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

0

Name: Jennifer SUMN
Date: August 28, 2006 at 05:59:23 Pacific

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.

0

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...