Remember Me?

#11
February 5th 09, 04:07 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 1,047
count days from a one date to another date

cheers

--
regards from Brazil
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
"Marcelo" wrote in message
...
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
Marcelo

"John" escreveu:

HI Marcelo
I Think you meant =DATEDIF(A1,B1,"D")
Regards
John
"Marcelo" wrote in message
...
if you prefere something different from the Mike perfect anwer, you can
use

=datedif(b1,a1,"D")

--
regards from Brazil
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.

#12
February 5th 09, 07:03 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Feb 2007 Posts: 8,651
count days from a one date to another date

No, John. The OP asked for "the number of days from A1 to B1", so your
--
David Biddulph

"John" wrote in message
...
Correction on formula
=A1-B1
Sorry for my blindness.
John
"John" wrote in message
...
HI
Try this: =B1-A1
You must format the cell as "General"
HTH
john
"confused!!" wrote in message
...
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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Mike H Excel Worksheet Functions 0 February 5th 09 02:10 PM RGlade Excel Discussion (Misc queries) 3 December 4th 08 07:36 PM David Excel Worksheet Functions 3 October 16th 08 07:06 PM Pascale Excel Discussion (Misc queries) 1 April 15th 08 03:27 PM Steve R Excel Discussion (Misc queries) 3 February 2nd 06 09:58 PM

All times are GMT +1. The time now is 09:25 PM.