Hi,
I managed to get the start and end date of the current week, the formula is built based on today's date. What I am looking for is to fetch the start and end dates of the previous week and it should start from monday and end on friday.
Example:
Today = 2021-07-12
Start of Prev Week = 2021-07-05
End of Prev Week = 2021-07-09
In addition to the above, would it be possible to get the start and end dates of a week based on the number of week of the year. Say if the number is 28, my results should be as below.
Start of week : 2021-07-12
End of week : 2021-07-16
Solved! Go to Solution.
Hi @Mario36
Solution based on your first ask. I took your workflow minus 7 day from current day to get last weeks start and end.
Hope this helps : )
Working on the second ask.
@atcodedog05 Awesome, this works. Let me know once you get a breakthrough on the second ask.
Hi @Mario36
Solution on 2nd ask.
Workflow:
1. Calculated first of year from datetimenow
2. Added N*7 days to it (n weeks, weeks is directly not supported)
3. Using your formula calculated first and last day of week.
Hope this helps : )
Happy to help : ) @Mario36
You are awesome too 😎 @Mario36 you already had done the heavy lifting in this usecase.
Thanks Mate
Cheers !