see ans in LATER post. "We must learn to have patience"

<billabong wrote in message
...
Hello: I'm trying to do the following on VBA:

If a cell contains the word "day" then write today's date, if not
leave blank.

If [e11] = "day" then [g11] = now Else [g11] = ""

however if I wanted to include more criteria, i.e., different
additional days (I believe the term is 'nested if statements') how
do I go about it.

For example:

If [e11] = "day" then [g11] = Now Else [g11] = ""
If [e11] = "T + 1" then [g11] = Now + 1 Else [g11] = ""
If [e11] = "T + 2" then [g11] = Now + 2 Else [g11] = ""
If [e11] = "T + 3" then [g11] = Now + 3 Else [g11] = ""
If [e11] = "T + 4" then [g11] = Now + 4 Else [g11] = ""


Thank you in advance

Manuel