count days from a one date to another date

  • Thread starter Thread starter confused!!
  • Start date Start date
C

confused!!

If in cell A1 i have a date 09/17/09 and date 10/30/08 in B1 i need to count
the number of days from A1 to B1

Please provide formula for doing so.
 
if you prefere something different from the Mike perfect anwer, you can use

=datedif(b1,a1,"D")


--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"confused!!" escreveu:
 
sorry for the typo error

anwer = answer
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Marcelo" escreveu:
 
no datedif runs as oldest date first so as A1 has 09/17/09 and b1 has
10/30/08 b1 came first on the formula

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"John" escreveu:
 
Hi Again
Now I notice it's not the same year, you're right, my apologies.
That proves to you, I'm human :)
Regards
John
 
cheers

;)
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"John" escreveu:
 
No, John. The OP asked for "the number of days from A1 to B1", so your
answer of -262 was correct.
 
Back
Top