View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JD MPLS
 
Posts: n/a
Default Cells populate on specific dates

I am trying to set up a vacation / holiday tracking form. In my company, we
receive all government holidays, but we cannot use the time until the holiday
has occurred. How can I get the form to populate 8 hours on the specific
holiday dates.
For example, the next holiday is presidents day, Monday February 20. On that
day I want cell R6 to automatically insert 8 hours for the earned time off.

The cell locations are R2 - R13.

Thanks in advance for the help.
Joel D MPLS