Average days between multiple dates

Posted to microsoft.public.excel.worksheet.functions

Jman

external usenet poster

Posts: 110

Average days between multiple dates

A1:A200
01/07/08
07/07/07
04/23/07
11/30/06

C1: I need average days between dates, considering leap years.

And is it possible to format C1 to equal.."2 month 3 days"
Thanks.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calc days between two dates and exclude leap year days	scoz	Excel Worksheet Functions	5	November 23rd 07 03:58 PM
Conditional Formatting Dates calculating 10 days and 30 days from a certain date	Sioux[_2_]	Excel Worksheet Functions	2	October 11th 07 02:04 PM
Average Days Open IF between dates	kathi	Excel Worksheet Functions	1	November 16th 06 11:37 AM
AVERAGE DAYS OPEN IF BETWEEN DATES	kathi	Excel Worksheet Functions	4	February 28th 06 03:45 PM
Calculating number of days between two dates that fall between two other dates	[email protected]	Excel Discussion (Misc queries)	5	October 26th 05 06:18 PM

All times are GMT +1. The time now is 01:57 AM.

Menu

About Us