Wednesday

March 4, 2015

March 4, 2015

Posted by **Amanda** on Thursday, November 15, 2007 at 8:52pm.

=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:18pmYou probably will need to write an IF statement.

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

- Excel -
**Amanda**, Thursday, November 15, 2007 at 9:25pmYeah 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:41pmGo to the help part of Excel and type in if statement. It will give you instructions.

- Excel -

- Excel -

**Answer this Question**

**Related Questions**

Today is my....... - Today is my birthday! I wonder what is my HOROSCOPE SIGN? ...

math - Chris received $1 on his first birthday,$3 on his second birthday,$6 on ...

English - Hi Miss Sue, Here is the final draft can you check it for me? Thank ...

MATH, HELP - what is the probability that at least 2 students in a class of 36 ...

math - 1. First of all, pick the number of times a week that you eat chocolate. ...

Englsih - 1. He gave the gold bracelet to me for my birthday. 2. He gave the ...

math - Your great uncle gave you $2 on your first birthday, $4 on your 2nd ...

math - Your great uncle gave you $2 on your first birthday, $4 on your 2nd ...

English - 1. What do you want for your birthday? - What I want for my birthday ...

Maths - Grandpa places money in an account on your first birthday and will place...