Thursday
July 30, 2015

Homework Help: Excel

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.

Answer this Question

First Name:
School Subject:
Answer:

Related Questions

More Related Questions

Members