excel97 subtract two dates to find number of days

L

Lee

I have tried solving this problem by referring to EVERY thread on this
subject and NOTHING works. I use excel 97 and the 'analysis tool pac'
is active in the add-ons. Simply subtracting A1 - B1 only works if the
different dates are within the same month and year. If the different
dates are from 2 different months, the result is a huge figure. I
tried the function, DateDif(A1,B1,"d") (or "md")and the result is NUM!
Reversing the dates result in the same NUM!
I'm getting crazy with this - someone out there please help.
lEE
 

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

DATEDIF vs. simple difference 5
days count between different date format 3
subtracting date/time 8
DATEDIF() The hidden function - You may find it useful. 1
Date+ returns #Num 7
Need help with formulae comparing date-based numbers 2
My discovery on adding months and days to a date! 8
Formula to calculate exact months and days between two dates 3

Top