Sorry I haven't been that clear have I.

Yes a more variable formula - the campaigns can run for anything from a week
to a year.

"Bob Phillips" wrote:

Are you looking for a more variable formula, or will the start and end dates
always span 4 months?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"STFC" wrote in message
...
Hi Bob

Wow, thanks for the quick response.

I was really after a formaula that would take into account partial months.

Therefore if Start Date = 15 Jan, End Date= 4th Apr

Jan=17 days, Feb=28days Mar= 31day and Apr=4 days, May=0, Jun=0 etc. This
is
for when campaigns ran in a year, and which months it ran in.

Andy.



"Bob Phillips" wrote:

C1: =DAY(DATE(YEAR(A1),MONTH(A1)+1,0))
D1: =DAY(DATE(YEAR(A1),MONTH(A1)+2,0))
E1: =DAY(DATE(YEAR(A1),MONTH(A1)+3,0))
--

HTH

RP
(remove nothere from the email address if mailing direct)


"STFC" wrote in message
...
Hello,

Hope someone can help.

A1 = Start date B1=End Date eg A1 = 1st Jan B1=4th April

C1=Days in Jan D1=Days in Feb E1=Days in Mar etc until Dec.

Therefore for the above example C1 would = 31days D1 = 28days E1 =
31days
and F1 = 4 days.

I have been playing around with IF and DATEDIF but I'm getting
nowhere.
Any
help would be much appreciated.