This is a promotion tracking spreadsheet. I need to track when the person was last promoted, and determine when they are eligiable for the next promotion date based on 548 days since their last promotion. In short - I need the cell L3 to return the value (+ 548 days) of cell E3, F3, G3, or H3, depending on which one was filled in most recent.
Answer from Richard Rost:
Well, you can use the MAX function to determine which of those four cells has the most recent date, then just add 548 days to it:
=MAX(E3:H3)+548
Easy enough?
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Excel Forum.
