Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF and DATE Formula Help PLEASE
I am trying to calculate review dates for over 500 people. I want to create
a sheet that calculates reviews in 6 months for new hires and every 2 years for existing staff. My example data is below and I'm to do the following calculations in Column C: Hire Date (A) Review Date (B) Next Review Due (C) 1/1/03 1/1/05 Formula here would = 1/1/07 (using =DATE(YEAR(B2)+2,MONTH(B2),DAY(B2)) 1/1/07 Formula here would = 7/1/07 (using=DATE(YEAR(A3),MONTH(A3)+6,DAY(A3)) 2/5/04 2/5/06 Formula here would = 2/5/08 3/8/07 Formula here would = 9/8/07 I am trying to create an iF statement that says IF Column B has a date then do the calculation =DATE(YEAR(B2)+2,MONTH(B2),DAY(B2)), but IF Column B is blank do the calculation =DATE(YEAR(A2),MONTH(A2)+6,DAY(A2)) I can not get it to work. Is it possible and if so, what is the write formula?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
formula to calculate future date from date in cell plus days | Excel Worksheet Functions |