Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sundays
I dl a timesheet template where the date is formatted to say Sunday, Monday
etc. (Eg 40017 displays Thursday in column A5 and 23/07/09 in column B5) I need a value of 1 in colum J5 if A5 = Sunday AND there is a value 0 in column H5 Currently the spreadsheet looks like this: A = Weekday B= Date C= Start work D= End work H= Daily hours worked J = Sundays worked |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate no. of Sundays in a month | Excel Discussion (Misc queries) | |||
Get all Sundays | Excel Worksheet Functions | |||
Networkdays plus Sundays | Excel Worksheet Functions | |||
# of Sundays in a year | Excel Discussion (Misc queries) | |||
No Sat & Sundays | Excel Discussion (Misc queries) |