To calculate the total accrued vacation from one date to another:

=((EndDate-StartDate)*AccuralPerDay)-AnyUsedVacation

To calculate the total accrued vacation from a point in history to today:

=((today()-StartDate)*AccuralPerDay)=AnyUsedVacation

Vaya con Dios,
Chuck, CABGx3


"HELP ME!!!" wrote:

I AM TRYING TO DISPLAY THE CURRENT MONTH OF ACCRUED VACATION.

EXAMPLE:

ACCRUED VACATION TIME
01/01/08 02/01/08 21.32
02/01/08 03/01/08 22.15
03/01/08 04/01/08 22.98
04/01/08 05/01/08 23.82
05/01/08 06/01/08 24.65
i HAVE CREATED A SUMMARY TAB WICH SHOULD DISPLAY THE CURRENT ACCRUED
VACATION TIME FOR A SPECIFIC EMPLOYEE.

I'M LOOKING FOR A FORMULA TO USE. THAT WILL ALWAYS DISPLAY THE ACCRUED
VACATION TIME IN REFERENCE TO TOAYS DATE.

SHOULD I USE AN =IF STATEMENT.
EXAMPLE:

=IF(C33)TODAY()
THIS IS AS FAR AS i AM GETTING AT THE MOMENT.