IF to SELECT CASE

[Guest]

Instead of having this IF statement
=IF(A1=DATEVALUE("1/1/04"),"NEW YEAR'S",IF(A1=DATEVALUE("1/19/04"),"MLK DAY","")
I would rather have a SELECT CASE statement. How do I do that? In particular, how do I reference the date cell
Thanks
Howar

 

[Don Guillett]

try
select case range("a1")

--
Don Guillett
SalesAid Software
(e-mail address removed)

Instead of having this IF statement:
=IF(A1=DATEVALUE("1/1/04"),"NEW YEAR'S",IF(A1=DATEVALUE("1/19/04"),"MLK DAY",""))
I would rather have a SELECT CASE statement. How do I do that? In

particular, how do I reference the date cell?

 

[J.E. McGimpsey]

Create a table of dates (say in column J) and names (in column K).
Then use

=VLOOKUP(A1, J:K, 2, FALSE)