Excel If Else Stmnt with Dates (Adding Days)

[xcelnovice]

Hi So I have a table....

A B
1 4/5/13

2 4/5/13

I'd luke to put a formula in B2 that says IF cell B1=B2 then add 14 days to the date, ELSE add 7 days to the date that I can copy down a large spreadsheet. The date changes through out the spreadsheet so I would need it to be general so if the 2 dates match add 14 days otherwise add 7.


Is this doable? Thanks to all the forum contributers.

 

[bbott]

Hello,

That would cause a circular reference. B2 cannot reference itself for a value. You could put the IF B1=B2 in B3. Would that work for you?

 

[xcelnovice]

Yes sorry I meant B3. Thank You

 

[xcelnovice]

Sorry IF B1=A2

 

[bbott]

OK, try this in cell B3:

=IF($B$1 = $A$2, B2 + 14,B2 + 7)

 

[xcelnovice]

Awesome! Thank You!

 

[bbott]

You're welcome!