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. |
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. |
All times are GMT +1. The time now is 03:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com