Forum Discussion
Need assistance to correct a formula
I am using the following formula to calculate weekly hours. I want to change it to calculate the hours with the starting on Monday going to Sunday and display the result in column G on the Sunday. ...
Thanks so much for your solution. As far as the dates go the table is for 2025. I appreciate your help so much. I am not knowledgeable in Excel, but it is an amazing tool. You guys are brilliant.
Then this confirms your solution was working except for the need to adjust the Weekday function. Without the 2nd parameter the function calculates as Sunday as 1 and Saturday as 7 and your formula stated where ‘equal to 7’ and hence why it was activated on the Saturdays instead of Sundays.
The formula could be changed to ‘equal to 1’ or the Weekday function 2nd parameter enter ‘2’ for Monday as 1 and Sunday as 7.