AndrewTrevayne
New Member
- Joined
- Jul 27, 2013
- Messages
- 8
Hi all,
Can you help me with a formula on date?
Basically, I want to add Years on the date based on a criteria.
Logic is:
If date in columnA is paired with X in ColumnB add 1 year to ColumnC
If date in columnA is paired with Z in ColumnB add 2 years to ColumnC
If date in columnA is paired with Y in ColumnB add 3 years to ColumnC
Thanks in advance.
Can you help me with a formula on date?
Basically, I want to add Years on the date based on a criteria.
Logic is:
If date in columnA is paired with X in ColumnB add 1 year to ColumnC
If date in columnA is paired with Z in ColumnB add 2 years to ColumnC
If date in columnA is paired with Y in ColumnB add 3 years to ColumnC
Thanks in advance.