I'm new too this so be patient!
I have devised a weekly timesheet which calculate hours and minutes worked
per day, and (later) calculates both overtime and time off (short days). Our
week begins on a Monday (even on Bank Holidays) and the only unlocked 'date'
cell is the first one (first Monday of the week). Can I use a formula in
validation to 'force' the input date to return the nearest Monday to that
input date. (I have tried to make it easy by using the format 'dddd
dd/mm/yy' but I still get sheet which start on a Sunday or Tuesday !)
Graham