View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
HELP ME!!! HELP ME!!! is offline
external usenet poster
 
Posts: 1
Default VACCRUED VACATION / DISPLAYED

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.