i am using the date tool to build a monthly time sheet, starting on the 26th of each month. but i need the time sheet to always start with a monday, even if it then leaves some days at the start of the week blank. at the moment i am using the date and day tool so every time the sheet starts on the 26th, it changes the day above to whatever the actual date is. any help would be great i can send the sheet or cells if that would help mrexcel.jpg
Bookmarks