First and Last Day of Previous Week

[briankuhlmann]

I am trying to use date formulas to feed a Dynamic Input. I need one formula that would grab the first day (Sunday) of the previous week. Then a second that would produce the last day (Saturday) of that week. I've fooled around with a few options and can't get what I need. Anyone have any suggestions?

For extra clarity, an example. If I was running the workflow today (10/27/21), I'd want the formulas to produce 10/17/21 as start of previous week and 10/23/21 as end.

Thanks

[atcodedog05]

Hi @briankuhlmann 

Here is how you can do it. You can create [date] using datetimetoday() and follow below.

Workflow:

Hope this helps : )

[chuckleswk]

you would use a formula to determine what day number today is and then do a datetimeadd formula to get to the upcoming Sunday and then do a datetimeadd to get to the Sunday for 2 weeks ago to get the day you want as the start. You would do the same thing to get the Saturday. Please see the attached screenshots and flow and let me know if this gets you the results you were looking for.

 

 

[DavidP]

Hi @briankuhlmann 

Something like this?

[briankuhlmann · Accepted solution]

Thanks to everyone for your input. I was able to take a few suggestions and put a spin on them to get this. 

[MichelleMitchellLutz]

This worked for me! Thanks for sharing.