conditional formula

J

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.
 
S

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"
 
Top