Excel If Statement + Dates

April 22, 2009 at 03:08:44
Specs: Windows XP
I have a set of dates in the format dd-mmm-yy in column a and have 2 conditions of jobs 1, 2 & 3 in column b.

I would like column c to:
- return the date in column a if the condition is 1
- add one month on if the condition is 2
- or add 3 months if the condition is 3

I've tried using an if statement, but have got very lost!

See More: Excel If Statement + Dates

Report •

April 22, 2009 at 05:18:34
Try this in column C


Don't forget to format column C as Date



Report •

April 22, 2009 at 06:45:14
Some folks might not consider "30 days" as the definition of a month.

How about:


Report •

Related Solutions

Ask Question