Posted by Amanda on Thursday, November 15, 2007 at 8:52pm.
I have an assignment where I have to create a birthday list. One of the tasks is to add a countdown til someone's birthday, I have the formula as:
=DAYS360($D$200,I3)
However how do I calculate it so if some's birthday past I can recalculate it so it is not negative.
Like if someone's birthday past it will say 105 days, where I want to add 365 to any negative amounts.

Excel  DrBob222, Thursday, November 15, 2007 at 9:18pm
You probably will need to write an IF statement.

Excel  DrBob222, Thursday, November 15, 2007 at 9:19pm
That is, IF the answer is negative, add 365; otherwise, calculate regularly.

Excel  Amanda, Thursday, November 15, 2007 at 9:25pm
Yeah but I can't figure out how to do that, how do I do an IF function within the calculation?

Excel  DrBob222, Thursday, November 15, 2007 at 9:41pm
Go to the help part of Excel and type in if statement. It will give you instructions.