Hi all,
in colum A i ve inserted dates. Every day i will add a value in column B in the specific line of today's date. And i need excel to sum the values of the last 7 days.
How can i do that ??
the main goal is to use excel to count if i exceed my allowed duty time per 7 day consecutive days.
Thank for your help.
ps : i am a beginner in Excel...i just know the very very basic operation for now...
in colum A i ve inserted dates. Every day i will add a value in column B in the specific line of today's date. And i need excel to sum the values of the last 7 days.
How can i do that ??
the main goal is to use excel to count if i exceed my allowed duty time per 7 day consecutive days.
Thank for your help.
ps : i am a beginner in Excel...i just know the very very basic operation for now...