View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Help with Formula

Try this in H9:

=IF(F9="WFM",G9+30,IF(OR(F9="WFM1",F9="WFM2",F9="W FM3"),G9+180,"not
defined"))

You do not say what you want to return if those conditions are not
met. You might like to change "not defined" to G9, or 0 ...

Format the cell as a date.

Hope this helps.

Pete

On Sep 3, 1:51*am, Yitzhack
wrote:
Hello all –
Please help!!! I can’t make this work. *I need a formula in cell H9 where if
cell F9=WFM add 30 days to date in G9, if WFM1, WFM2, or WFM3 in cell F9 add
180 days to date in G9.
Thanks in advance

--
Regards
YM