Excel

posted by .

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 -

    You probably will need to write an IF statement.

  • Excel -

    That is, IF the answer is negative, add 365; otherwise, calculate regularly.

  • Excel -

    Yeah but I can't figure out how to do that, how do I do an IF function within the calculation?

  • Excel -

    Go to the help part of Excel and type in if statement. It will give you instructions.

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. Today is my.......

    Today is my birthday! I wonder what is my HOROSCOPE SIGN?
  2. MATH, HELP

    what is the probability that at least 2 students in a class of 36 have the same birthday?
  3. math

    Chris received $1 on his first birthday,$3 on his second birthday,$6 on his third birthday,$10 on his four birthday.How much money will Chris receive on his eighth birthday if the pattern continues?
  4. math

    John receives $200 for his birthday. He buys 4 DVDs at $12.95 each. Sales tax is 6.25%. How much birthday money does he have left?
  5. math

    1. First of all, pick the number of times a week that you eat chocolate. This number must be more than one but less than ten. 2. Multiply this number by 2 (just to be bold). 3. Add 5 (for Sunday). 4. Multiply it by 50. 5. Add 1750. …
  6. English

    Hi Miss Sue, Here is the final draft can you check it for me?
  7. Math

    Ok so in class this is what our teacher had us do.... 1.Pick a number to represent the number of times you would like to have chocolate in a week (more than once, but less than 10 times). 2.Double this amount (just to be bold). 3.Add …
  8. English

    One more question related to 'for' goes as follows. Thank you for your explanation. 11. The nice gift for my birthday was a dictionary. 12. A nice gift for my birthday was a dictionary. (Q1: Do we have to use 'the' or 'a' before 'nice …
  9. English

    What is the part of speech of "for my birthday" in each sentence?
  10. English

    1. Today is my birthday. One of my family members knew that. I have a sister. She gave me a watch for my birthday. (Is this passage grammatical?

More Similar Questions