Rubber Beaked Woodpecker
Board Regular
- Joined
- Aug 30, 2015
- Messages
- 210
- Office Version
- 2021
Hi all 
Column A displays the date in the following format 26/07/2024
Column X displays the number of hours worked for each date.
I would like a formula in cell Y1 to display the total number of hours worked for the last six days but I am unable to fathom this
Any help please RBW

Column A displays the date in the following format 26/07/2024
Column X displays the number of hours worked for each date.
I would like a formula in cell Y1 to display the total number of hours worked for the last six days but I am unable to fathom this

Any help please RBW