Ozwazza
asked on
Running date formula in excelsheet
Hello, I have a column that includes an employee start date (i.e. 1/4/2002). I was hoping to put in an allowance column, for each employee, to have a formula which automatically inserts their $200 allowance when they have work a full year.
Look forward to your solution
Look forward to your solution
DATEDIF is a "secret" function that has been part of Excel for a long time, but was only documented in Excel 2000. Even though it is undocumented, you can still use it for problems like this.
If you want to learn more about the DATEDIF function, Microsoft Excel MVP Chip Pearson has a good webpage on it: http://www.cpearson.com/excel/datedif.aspx
If you want to learn more about the DATEDIF function, Microsoft Excel MVP Chip Pearson has a good webpage on it: http://www.cpearson.com/excel/datedif.aspx
ASKER
Hello excel gurus, the datedif function will not work because it is always >=1 if the year is >2013. I can only write in pseudocode (showing my age!)
IF (start date year) <= (Year(today)-1) THEN
IF (start date month) >= (month(today)) THEN
IF (start date day) >= (day(today)) THEN
ALLOWANCE=200
END IF
END IF
ELSE
IF (start date month) >= (month(today) THEN
IF (start date day)>=(day(today)) THEN
ALLOWNCE=200
END IF
END IF
END IF
can someone give me a an excel formula for that?
Cheers
Warren
IF (start date year) <= (Year(today)-1) THEN
IF (start date month) >= (month(today)) THEN
IF (start date day) >= (day(today)) THEN
ALLOWANCE=200
END IF
END IF
ELSE
IF (start date month) >= (month(today) THEN
IF (start date day)>=(day(today)) THEN
ALLOWNCE=200
END IF
END IF
END IF
can someone give me a an excel formula for that?
Cheers
Warren
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Wonderful, cheers
=IF(DATEDIF(A1,TODAY(),"y"
It will return an empty string (looks like a blank) if the employee has worked less than one year. It will return 200 on their anniversary date and thereafter.