Retrieving date values

I

Ify

Hi ,

Many thanks with the date text formular, but I am finding it difficul
to apply it in the context that i need it for.
for example :

I am trying to use the below code which does not seem to work t
retrieve all date values before the month of april 2004 separately an
then from the month of apr 2004 onwards

=IF(TEXT(P1,"MMM-YY")<"apr-04","PR-APR",TEXT(P1,"MMM-YYYY"))

The problem with this code is that the text "pre-apr" does not sho
up.


thanks
if
 
Top