Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timesheet -
I am updating an exisitng Excel sheet used for timesheet and I need to embed
logic in the sheet that will prohibt the entry of time on non-work days in a period. For example, I want the person completing the sheet to only be able to add hour worked time on m-f days and not the weekend. I looked in the templates even for biweekly sheets, it always assumes that the period starts on a Monday. Please provide insight. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timesheet -
Datavalidation, allow custom
=WEEKDAY($A2,2)<=5 assuming the dates are in a column and that A2 is the first date you would refer to then you can just copy and paste special as validation to the other dates The validation has to be in the cell(s) where you are suppose to type the hours -- Regards, Peo Sjoblom "LT AREA" <LT wrote in message ... I am updating an exisitng Excel sheet used for timesheet and I need to embed logic in the sheet that will prohibt the entry of time on non-work days in a period. For example, I want the person completing the sheet to only be able to add hour worked time on m-f days and not the weekend. I looked in the templates even for biweekly sheets, it always assumes that the period starts on a Monday. Please provide insight. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Timesheet | Excel Worksheet Functions | |||
Timesheet | Excel Discussion (Misc queries) | |||
Timesheet help | Excel Worksheet Functions | |||
Timesheet | Excel Worksheet Functions | |||
timesheet | Excel Worksheet Functions |