Months of review
Yep that's answered it, thank you.
"Bob Phillips" wrote:
=TEXT(DATEVALUE("01-"&J17&"-1900")+((MOD(MONTH(DATEVALUE("01-"&J17&"-1900"))
,3)=0)+1)*31,"mmmm")
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Pasty" wrote in message
...
Hi I am try to set it up on a risk register when to review their actions
at a
certain date after the actions have been set, initially I was under the
impression it was always the month after but have since found out it is
more
complicated than this:
Action Date Review Date
November December
December or January February
February March
March or April May
May June
June or July August
August September
September or October November
I have been messing around with an IF function along the lines of
=IF(AND(J17="December",J17="January"),"February",I F(J17="November","December
",IF(J17="February","March",IF(AND(J17="March",J17 ="April"),"May",IF(J17="MA
Y","June",IF(AND(J17="June",J17="July"),"August",I F(J17="August","September"
,IF(AND(J17="September",J17="October"),"November") ))))))
But this isn't working so I was wondering if there was a simpler way of
doing it?
|