Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA code to populate 1000's of cells? | Excel Discussion (Misc queries) | |||
How can I find and format specific cells automatically in Excel? | Excel Worksheet Functions | |||
how to delete contents of cells having specific data | Excel Discussion (Misc queries) | |||
Count cells in a column that contain dates | New Users to Excel | |||
Locate and delete specific cells | Excel Discussion (Misc queries) |