Calculating dates based on Quarters.

[John Weidenfeller]

So I have Software release with availability dates in the following format:

Rel 1 1Q 2003
Rel 2 3Q 2003
Rel 3 2Q 2004
Rel 4 4Q 2004
etc
etc

Then when a person orders the software release they also include a ship date
in the same date format as above.

What formula can I use to verify that the S/W release is available for the
ship date requested???

Since 1Q 2004 isn't a date format I can't do a simple less than equal to
formula???

Thanks
John

 

[acw]

John

If you have a list of software release dates, have you
tried using a VLOOKUP to test for the appearance.
Something like
=VLOOKUP("1Q 2003",lookuprange,1,FALSE).

If it is found, then 1Q 2003 will result otherwise there
will be an error message.


Tony