conditional formula

[Janet58]

I am trying to create a formula with the condition based an a Letter is this
possible
Skilled Unskilled Day 1 Day 30 Day 60
Unskilled Date

4-Dec-08 2-Jan-09 1-Feb-09
If U I want to I need to calculate a date if S I would like it to stay blank.

 

[Satti Charvak]

Try using the formula:

=IF(MID(E16,FIND("[",E16)+1,1)="S","No date","Calculate Date")

Don't forget to place your code instead of "No Date" and "Calculate Date"