I think the key is that I need to define a wild card (if possible)
to look for either the 'x' at the end of the date to bring back
'4' or a 'z' at the end of the date to bring back an '8'.

Yes, that's exactly what you need to do. Are "x" and "z" genreric
placeholders or do you want to look for literal "x" or "z" ?

If they're generic placeholders then they need to be defined somehow.


--
Biff
Microsoft Excel MVP


"Steve M" wrote in message
...
Hello,
I'm hoping someone can figure this out. I am trying to add a value to
B1 using the following:
I started out with =IF(ISBLANK(A1),"",8)
A1 will either be blank or contain a date. As an example I want to
change the above so that if I enter in A1 the date of May-7x the the
value in B1 will return a 4. And if I enter the date of May-7z into
A1 then the value returned in B1 should be 8.

So to summarize, B1 should either be blank, contain a 4 or contain an
8. I think the key is that I need to define a wild card (if possible)
to look for either the 'x' at the end of the date to bring back '4' or
a 'z' at the end of the date to bring back an '8'.

Its a bit confusing to explain, hopefully you can understand.

-Thanks