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

[u] 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.

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"

--
Kind Regards,
Satti Charvak
Only an Excel Enthusiast


"Janet58" wrote:

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

[u] 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.