# Thread: Diffence in Dates (Office 2000)

1. ## Diffence in Dates (Office 2000)

Hi,
What formula would I use that would give me the difference between two dates in days. In other words, if I have 6/30/04 in Col A and 6/15/04 in Col B, what formula would I put in Col C to give me "15" or "15 days".
Thanks!

2. ## Re: Diffence in Dates (Office 2000)

HI,

Never mind. <img src=/S/doh.gif border=0 alt=doh width=15 height=15> It was in the formating.

3. ## Re: Diffence in Dates (Office 2000)

Try this
=DATEDIF(B1,A1,"d")

the oldest date always is first

4. ## Re: Diffence in Dates (Office 2000)

You could use
=A1-B1
or
=ABS(A1-B1)
to avoid negative results, but as Louise found out the result should be formatted as a number.

5. ## Re: Diffence in Dates (Office 2000)

Hi Tony:

The advantage for Louise to know function DATEDIF, is that also it can use it to obtain years and months

=DATEDIF(A1,B1,

6. ## Re: Diffence in Dates (Office 2000)

Hi,
Thanks for the replies! Didn't know about ABS or DATEDIF functions.
What I did was a spreadsheet that shows when items that we are producing are due to be completed, when they actually were or when they are estimated to be. Some were early and some were late. Having minus days are ok in the case.

7. ## Re: Diffence in Dates (Office 2000)

Note: DATEDIF can't handle negative date differences, it'll display an error code if the second date is before the first one. Simply subtracting the dates as suggested by Tony does work for negative differences.

8. ## Re: Diffence in Dates (Office 2000)

The function worked, but it doesn't show up in my list of functions or in Help. Are there other functions that work that aren't listed? Where would I find out about them?

9. ## Re: Diffence in Dates (Office 2000)

Here is some info on "DateDif" Courtesy of Chip Pearson.

Steve

10. ## Re: Diffence in Dates (Office 2000)

As far as I know, DATEDIF is the only undocumented function (although it is reputed to be in the online help for Excel 2000; I can't verify that, since I went from Excel 97 to Excel 2002/XP.)

You can read more about it in The DATEDIF Function on Chip Pearson's site.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•