=IF(AF251="Ongoing","31/12/2007" ....

Is that what you're asking?

Dave
--
Brevity is the soul of wit.


"Pasty" wrote:

I have this function which selects specific months for review dependent on
the month they were set to have actions due.

=IF(AF251="Ongoing","July",IF(AB251="Risk -
Action","January",TEXT(DATEVALUE("01-"&AF251&"-1900")+((MOD(MONTH(DATEVALUE("01-"&AF251&"-1900")),3)=0)+1)*31,"mmmm")))

Is there any way to make this read a date i.e. 31/12/2007 rather than just a
month.