View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
liztownsend liztownsend is offline
external usenet poster
 
Posts: 1
Default Help need formula for working out date overlaps

Hope someone can help, I'm looking for a formula to work out date overlaps.
e.g.
If my key dates are 1/11/08 to 30/11/08
I want to auto calculate how many days the following overlap with my key dates
01/01/08 to 31/12/08
16/11/08 to 05/12/08
etc

thanks!
--
Liz