You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I'm looking to have a table with one column of dates, another column of days and the 3rd column calculated by adding the two and excluding the weekends. Say if date Jan 1 falls on a Monday and i need to add 8 days, the resulting 3rd column will be Jan 10 (Wed the following week). I followed the following article but it is a straight days add.
Thanks in advance for your help
Hi @Fulbert Lato ,
You may try the following SQL query:
2 * FLOOR(T1.'Period' / 5) +
WHEN 'Start Date'::Date->getDay() = 0 THEN 1
WHEN 'Start Date'::Date->getDay() = 6 THEN 2
WHEN ('Start Date'::Date->getDay()) + T1.'Period' % 5 > 5 THEN 2
AS 'End Date'
The query counts the number of Saturdays and Sundays for your period plus checks if the Start Date belongs to the weekend and "extends" the period (i.e. moves the End Date further) for the calculated number of holidays.
Please refer to our support. Attach the Page Storage Format (upper right corner -> menu ... -> View Storage Format), so we'll be able to recreate exactly your source table and the Table Transformer macro settings. If you don't see this option, ask your Confluence administrator to do it for you.