Values between Start and Finish date

[mohammadkhatimi]

Hi,

My requirement is to capture count of days (week-wise) between Start and Finish date rest will be blank

Below is the output for reference:

Application and data is attached.

Please do the needful ASAP

Thanks in Advance,

Regards,

Mohammad

[mohammadkhatimi]

okay..Thank you..

Is it possible to show week wise total?

[sunny_talwar]

Can you elaborate with an example?

[mohammadkhatimi]

PFA of the output sheet..

Also,

I want to create Months if the week falls between two months.

For e.g. Week start is 30th Aug 2015 and weekend is 5th Sep 2015.

So it should show Month as Sep (5 days) as no. of days is more than Aug(2 days).

I want to show trend.

[mohammadkhatimi]

gwassenaar‌

From backend, its giving me week wise total..

Can u please help me to redefine months..based on Week..

For e.g. Week start is 30th Aug 2015 and weekend is 5th Sep 2015.

So it should show Month as Sep (5 days) as no. of days is more than Aug(2 days).

Regards,

Mohammad

[sunny_talwar]

Try this

=Sum(Aggr(If(Weekend >= Start and WeekStart <= Finish,

If(Round(Finish - WeekStart) <= 7, Round(Finish - WeekStart) + 1, Round(Weekend - Start)) - If(Round(Finish - WeekStart) <= 7, 0, RangeMax(Above(Round(Weekend - Start)), 0))), [Main Stage], [Sub-Stage], Acti, Start, Finish, WeekStart))

[mohammadkhatimi]

gwassenaar‌

Please help me in this...

[mohammadkhatimi]

stalwar1‌

Please help me in this..

[sunny_talwar]

Help you on what? I did respond to your question above... what is wrong with it?

[mohammadkhatimi]

I want to create Months if the week falls between two months.

For e.g. Week start is 30th Aug 2015 and weekend is 5th Sep 2015.

So it should show Month as Sep (5 days) as no. of days is more than Aug(2 days).

[sunny_talwar]

Are you just randomly throwing out new requirements or is this linked to the response I gave for the last one? I suggest you to create a new thread for a new incremental requirement....

Thanks,

Sunny