Remember Me?

#1
May 3rd 06, 09:59 AM posted to microsoft.public.excel.misc
 Renz09 Posts: n/a
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

#3
May 3rd 06, 10:18 AM posted to microsoft.public.excel.misc
 Pete_UK Posts: n/a
Calculating Number of days from one date to another

Your example just states the number of days, and this can be obtained
by subtracting one date from the other and formatting as number with
zero decimal places. You might also look into using DATEDIF if you want
to express the result as x months y days.

Hope this helps.

Pete

 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 Mifty Excel Discussion (Misc queries) 7 February 13th 06 11:36 PM [email protected] Excel Discussion (Misc queries) 5 October 26th 05 06:18 PM shaunl Excel Discussion (Misc queries) 5 July 13th 05 02:38 PM Ron Excel Worksheet Functions 0 January 18th 05 01:59 AM Elboo Excel Worksheet Functions 5 November 22nd 04 03:44 PM

All times are GMT +1. The time now is 08:29 AM.