Quarterly Calendar

sinsarahty

Every quarter has the same meetings (10 of them), each mirroring their tasks and scheduling of the previous quarter (i.e. always on the 2nd Tuesday of the first month of the quarter . . .)

How can I pick up an entire quarter and duplicate it having the dates auto fill for the following quarter?

sinsarahty

Okay, so by using YEARDAY I can come up with the day of the year that a meeting is going to be held. That gives me the perfect starting point for my schedules.

Can anyone tell me how I can turn that number back into a date?

(I could also use YEAR, WEEKNUMBER and WEEKDAY if that would make it easier)

sinsarahty

Got it. Figured it out myself. Thank you though.

Andrée Starå

https://community.smartsheet.com/discussion/129515/quarterly-calendar

Hi,

I hope you're well and safe!

Excellent! I'm glad you got it working!

Feel free to share the solution because It might help others!

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Please support the Community by marking your comment as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!