Retrieving date values

  • Thread starter Thread starter Ify
  • Start date Start date
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Returning the month (mmm) from cell in date format dd/mm/yyyy 1
Date / Time problem 4
Dates? 2
Lookup value and return column offset value 5
months on separate tabs 1
Show a date based on another date 1
Help required on working with date 5
Default date format (with shortcut keys) 2

Back
Top