View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
papou
 
Posts: n/a
Default Calculating Number of days from one date to another

Hello
Assuming 05-June-06 is in B1 and 01-May-06 is in A1
Formula in C1 :
=B1-A1
And format as Standard

HTH
Cordially
Pascal


"Renz09" a écrit dans
le message de news: ...

I need I formula to calculate the number of days from one date to
another.

Example:
01-May-06 to 05-June-06 = 36 days

I've tried the 360 day function, but the problem being it calculates
based on 360 days not the number of days in each month. Each month is
either 28, 30,or 31 days in it. I need a formula that calculates on
the month not the day. Please somebody help me with this!!


--
Renz09
------------------------------------------------------------------------
Renz09's Profile:
http://www.excelforum.com/member.php...o&userid=34069
View this thread: http://www.excelforum.com/showthread...hreadid=538357