Excel

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.

  1. 👍
  2. 👎
  3. 👁
  4. ℹ️
  5. 🚩
  1. You probably will need to write an IF statement.

    1. 👍
    2. 👎
    3. ℹ️
    4. 🚩
  2. That is, IF the answer is negative, add 365; otherwise, calculate regularly.

    1. 👍
    2. 👎
    3. ℹ️
    4. 🚩
  3. Yeah but I can't figure out how to do that, how do I do an IF function within the calculation?

    1. 👍
    2. 👎
    3. ℹ️
    4. 🚩
  4. Go to the help part of Excel and type in if statement. It will give you instructions.

    1. 👍
    2. 👎
    3. ℹ️
    4. 🚩

Respond to this Question

First Name

Your Response

Similar Questions

  1. Career Planning

    Which of the following defines a short-term goal? A.tasks that you set to accomplish specific things in a short period of time****** B. tasks that must be completed for a job performance evaluation C. tasks that you must complete

  2. Finance

    An insurance company is offering a new policy to its customers. Typically, the policy is bought by a parent or grandparent for a child at the child's birth. The details of the policy are as follows: The purchaser (say, the parent)

  3. Mental & Emotional Health

    1.)True & False Life changes, whether they are positive or negative, can cause stress True or False 2.)Making a list of what you have to do & identifying what is most is an example of ? A.)Mental rehearsal of tasks B.)Relaxing by

  4. Math

    On his 12th birthday Enoch's grandparent's deposited $25 into a savings account for him. Each month after that up to and including his 20th birthday, they deposit $10 more than the previous month. How much money will Enoch have on

  1. Composition

    Revise the following paragraph, improving it without changing its overall meaning. Pay particular attention to sentence structure. Ever been assigned to work on a group project for class! Many students dread group projects:

  2. Math

    Use a ruler to create a 6" x 8" rectangle. Cut rectangle on a diagonal. Use the two triangles to create four new shapes. List the most specific shape and its perimeter

  3. Math

    Julia spent 1/3 of her birthday money and she lost half of the rest now she has $10 left how much did she get for her birthday

  4. MATH, HELP

    what is the probability that at least 2 students in a class of 36 have the same birthday? Do i punch this in to the calculator or how did you found this way or method for your solution: Log(365!) = 1792.3316 Log(329!) = 1581.7202

  1. college math

    Assume that there are 16 board members: 10 females, and 6 males including Larry. There are 4 tasks to be assigned. Note that assigning the same people different tasks constitutes a different assignment. (1) Find the probability

  2. English

    What is the part of speech of "for my birthday" in each sentence? An adverb phrase or an adjective phrase? Would you check them, please? Can a phrase be either an adjective phrase or an adverbial phrase? Thank you. 1. What do I

  3. history

    I need to someone to write a timeline for me. Assignment Recall that the project requires you to create a timeline that identifies significant events of the Renaissance and Protestant Reformation. Your assignment is to identify at

  4. Math

    Julia spent 1/3 of her birthday money. Then she lost 1/2 of the rest. She now has $10.00 dollars left.how much did she get for her birthday.

View more similar questions or ask a new question.