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. 👍 0
  2. 👎 0
  3. 👁 228
  1. You probably will need to write an IF statement.

    1. 👍 0
    2. 👎 0
  2. That is, IF the answer is negative, add 365; otherwise, calculate regularly.

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

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

    1. 👍 0
    2. 👎 0

Respond to this Question

First Name

Your Response

Similar Questions

  1. 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

  2. health

    making a list of what you have to do and identifying what is most important is an example of. . . . A.mental rehearsal of tasks. B.relaxing by list making. C.time management. D.making connection

  3. 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

  4. 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)

  1. P.E

    Making a list of what you have to do and identifying what is most important is an example of? A.Mental rehearsal of tasks B.Relaxing by list making C.Time management D.Making connections Is the answer C?

  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. 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

  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. 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

  2. improving it without changing its overall meaning

    Ever been assigned to work on a group project for class! Many students dread group projects: because one student typically does most of the work. Unfortunately for some, group work does not end when students leave school, many

  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

    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

You can view more similar questions or ask a new question.