This is what I do to be able to get the range of date that I needed for that week.
But I want it to be automated, like in just a press of a button I could grab the date from last week.
Monday to Sunday, I saw some articles but they just subtract 7 from the current date.
I want it grab the whole week's date range (Monday to Sunday) no matter what day it is, even if it's Wednesday.
Should I do a Case Statement?
Case( Field = MondayCurrentDate - 7) If it is a Tuesday it would be minus 8 , Wednesday minus 9?
Then after that I want to have a field where in I will have the Days between Dates that occurred on the field.
If an employee is 1 day absent on that week they will only get 4 days.
But the thing is the field has a lot of identical values, can I filter it?
All 8.28.18 that appeared will be counted as 1 date only.
I don't know If I stated it clearly.