Current Work Day

[#1]

Guys,

I'm struggling with something that should be a quick aggr function with rank.

I have my booking dates and want to show it by WORK DAY. Like the example bellow.

How can I calculate the yellow column?

BOOKING_DATE	BOOKING_DAY	BOOKING_WORKDAY
9/2/2014	2	1
9/3/2014	3	2
9/4/2014	4	3
9/5/2014	5	4
9/8/2014	8	5
9/9/2014	9	6
9/10/2014	10	7
10/1/2014	1	1
10/2/2014	2	2
10/3/2014	3	3
10/6/2014	6	4
10/7/2014	7	5
10/8/2014	8	6
10/9/2014	9	7
10/10/2014	10	8

Thanks,

Fabio

[#2]

Hi Fabio!

Try this one - it's a solution via the script

Hope this helps

Christoph