Timesheet -

[Guest]

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.

 

[Peo Sjoblom]

Data>validation, 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