Hi,

What is the simplest way to check 5 different dates to see if they lie
within 4 seperate date ranges(Yearly quarters) and count the number of days
attributable to each quarter?

eg
Q1 Jan 1 - Mar 31
Q2 Apr 1 - Jun 30
Q3 Jul 1 - Sep 30
Q4 Oct 1 - Dec 31

Voyage: 24 Mar, 25 Mar, 4 Apr, 5 Apr & 14 Apr

This voyage to place 7 days in Q1 (24 Mar to 31 Mar)
& 14 Days in Q2 (1 Apr to 14 Apr)

I need to check around 200 voyages at a time.

Is there an easy way?


--
Many Thanks,
CK