date formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm having data with date of commissionings. I want to change the data as,
"01/04/2005" before commissioned as 1, and "01/04/2005" after commissioned as
2,"01/04/2006" after commissioned as 3.Like that I want to change my data. I
used formula
=IF(DATEVALUE(F3)<1/4/2005,1,IF(DATEVALUE(F3)>=1/4/2005,2,IF(DATEVALUE(F3)>=1/4/2006,3)))
but it showing 2 at the date 31/01/2005 actually it has
to show 1.why?
Is there any mistake in formula ?
can any one help on this? very necessary
 
thanks for cooperation

Toppers said:
If F3 is Date format:

=IF(F3>=DATEVALUE("1/4/2006"),3,IF(F3>=DATEVALUE("1/4/2005"),2,1))

NOTE change of order of testing dates.
Click to expand...
 

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

date formula 4
DATE FORMULA 3
please suggest a formula 2
Connecting multiple IF statements into one formula 2
Counting if Date1 is after and Date2 is before another date 5
Excel Formula Help! 2
SUM and IF using two date ranges 2
Specific Date from a Range 3

Back
Top