If A1 has the start date and B1 has the later date then =B1-A1 will yield the
number of days if formatted as General.
--
Gary''s Student


" wrote:

Hi,


I would like to know how i can calculate the number of days between two

dates that fall between another two dates (ie callender quarters)


Eg


Q1 1/1/2005 - 31/3/2005 (these dates can be variables, Q1,Q2.. etc)


1/1/2005 - 31/12/2005 What number of days between these two dates would

fall between the dates above?


Can anyone help please


Cheers!!!