Posted to microsoft.public.excel.programming

Salam[_2_] Salam[_2_] is offline

external usenet poster

Posts: 1

Calculating date overlapping

If I have two group of dates and need to calculate the
ovelapping period;
i.e
group 1 start date 12/12/2003 and finish date 1/May/2004
group 2 start date 1/1/2004 and finish date is 1/Feb/2004
so the overlapping is from 1/1/2004 until 1/Feb/2004

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
overlapping date ranges	kalchakra	Excel Discussion (Misc queries)	2	March 3rd 11 09:54 PM
Calculating overlapping time periods	Arlette	Excel Worksheet Functions	1	December 9th 06 02:14 AM
Calculating overlapping time periods	Arlette	Excel Worksheet Functions	1	December 9th 06 12:31 AM
Calculating overlapping time periods	Arlette	Excel Worksheet Functions	0	December 8th 06 09:35 PM
Overlapping or Duplicate Date & Time	Mike	Excel Worksheet Functions	1	August 17th 05 10:22 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us