Conditional formula for dates
Thank you!!!
"Jacob Skaria" wrote:
Try the below..If D do not contain z or y then return cell A1 date itself.
=A1+IF(D1="z",10,IF(D1="y",20,0))
If this post helps click Yes
---------------
Jacob Skaria
"BMoran" wrote:
I'm looking for help with a conditional formula.
A B C D
1 11/1/09 z
I'd like a formula in column B to calculate days depending on columns A and
D. If column D is "z", i'd like to add 10 days to column A. If column D is
"y", I'd like to add 20 days to column A.
Thanks for any assistance!
|