dates in formulas

Hi all, I know how to add one year to a date with this function =DATE(YEAR(C5)+1,MONTH(C5),DAY(C5)) How can I expand this to say if Cell E5 is less than 61 (days), then add one year. Thank you, I appreciate the help

Hi, I'm looking to calculate "Weeks Active" for vacancies that are advertising. I have "Date Opened" in Column P, "Date Closed" in Column Q and today's date in Column R. If the closing date is populated, I want Column S to calculate time elapsed between Col P and Col Q. If the vacancy is still...

I'm struggling a bit with conditional formatting and dates. I dont think the answer is overly complicated but for whatever reason I am stumped. I think I might not understand if/when/how to apply <= and a date. I have a column F (Start Date) and a Colum G (End Date) and would like to set up...

Hi all, Sorry for the lengthy description. I am a newbie here and thought I would include as much info as possible: I am attempting to put together a schedule (list of dates at this point), where each widget will need to be serviced on a set interval of days from a start date. Therefore I...

One of my managers asked me to do this for him, and I've been trying most of the day to wrap my brain around a 'simple' solution to this and coming up dry. I need to have the cells in column G color based on a value in themselves or in adjacent cell in column H. I have three columns (F,G,H)...

This sheet monitors individual's physical fitness scores. If members score <90 they must retest every 6 months with a diagnostic performed two months prior (4 months mark). If they score 90 or higher they will retest yearly with a diagnostic performed at 10 months. I have several rows of...

Hello guys, I'm completely new to this forum so, hello everyone! :cool: I'm a beginning user with Excel, and I really could use some help. I would like to know the following because I just can't figure it out, even after spending some time on the web. I currently have a cell with a "Start...

Hi Everyone, I hope you're all doing fine. I need your help to get the correct formula for the #ofPaymentsMade and the NextPaymentSchedule. Below is sample table. I hope some can help me on this. <tbody> Start Date End Date Duration Payment Term # of Payments Made Next Payment Schedule...

Hi everyone, I hope you could help me out with this question: I would like to have the formula to insert in the cell F2, F3 and F4. If the date in cell E2 is between dates in A and B column should retrieve the right value/text in column C (to cell F2). The same for dates in cell E3, E4 and E5...

Hi everyone, I hope you could help me out with this question: I would like to have the formula to insert in the cell F2, F3 and F4. If the date in cell E2 is between dates in A and B column should retrieve the right value/text in column C (to cell F2). The same for dates in cell E3, E4 and E5...

Hello! I'm trying to play with numbers (Excel 2010) from counting elk that crossed by a game camera. When using the SUMIFS function to categorize data by month (elk counted in February, March, April, May), the values given by my April and May formula are off by 1 compared to the value given by...