View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John[_22_] John[_22_] is offline
external usenet poster
 
Posts: 694
Default count days from a one date to another date

Hi Marcelo
We all make errors, welcome to the human race.
Have a nice day
John
"Marcelo" wrote in message
...
sorry for the typo error

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



"Marcelo" escreveu:

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:

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.