Date function
 

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.

Date function
 

=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.

Date function
 

What I want it to do is rather than it to just read the month i.e. if someone
input July it would automatically change to the relevant month I want it to
be able to see that if they put in a specific date i.e. 07/07/07 it would see
that it is the month of july involved and apply the same rules to show the
month of review.

"Dave F" wrote:

=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.

Date function
 

Your formula outputs a date, it doesn't read one. How does the date input
relate to that formula?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Pasty" wrote in message
...
What I want it to do is rather than it to just read the month i.e. if
someone
input July it would automatically change to the relevant month I want it
to
be able to see that if they put in a specific date i.e. 07/07/07 it would
see
that it is the month of july involved and apply the same rules to show the
month of review.

"Dave F" wrote:

=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.

Date function
 

The way it works is that this formula is sat in AG251 (or whichever one)
=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")))

It then looks at what month is input in AF251 and then puts the relevant
month of review which is based around these rules:

Due
Month of review
Risks with actions due in Nov December
Risk-Action
January
Risks with actions due in December or January February
Risks with actions due in February March
Risks with actions due in March or April May
Risks with actions due in May June
Risks with ongoing actions July
Risks with actions due in June or July August
Risk with actions due in August September
Combined effect of actions October
Risks with actions due in September or October November

The current formula does this but instead of the input for the formula being
a month I would like it to be an actual date where it is clever enough to
pick up what month it is.




"Bob Phillips" wrote:

Your formula outputs a date, it doesn't read one. How does the date input
relate to that formula?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Pasty" wrote in message
...
What I want it to do is rather than it to just read the month i.e. if
someone
input July it would automatically change to the relevant month I want it
to
be able to see that if they put in a specific date i.e. 07/07/07 it would
see
that it is the month of july involved and apply the same rules to show the
month of review.

"Dave F" wrote:

=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.