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

Cells populate on specific dates
 

I'll use President's day as an example. Let's say the date for president's
day is in R2 (it has to be in date format to work)

=IF(AND(TODAY()=R2,TODAY()<="12/31/2006"),8,0)

The logic is:
If today is at least 2/20/2006 (in this case) and no later than 12/31/2006
than 8 is placed in the cell, otherwise it is populated with 0.

If you want the formula without the end of the year restriction than use the
following:
=IF(TODAY()=R2,8,0)

Hope that helps

"JD MPLS" wrote:

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