VACCRUED VACATION / DISPLAYED
I don't understand what you are trying to do, but if you post back
with some further explanation please make use of the CAPS LOCK to
avoid typing only in upper case - it is difficult to read and
considered to be the equivalent of shouting (i.e. rude).
Pete
On Feb 4, 5:59*pm, HELP ME!!! <HELP
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.
|