Cells populate on specific dates

J

JD MPLS

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
 
J

JNW

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
 
Top