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


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