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

[prieper]

not clear on the required outcome:

Do you wish to know the days btw both dates? and then divide by 7? what to do with decimals?

Or do you wish to know the number of weeks elapsed betw the events?

[mohammadkhatimi]

I want to allocate days on the basis of Start and Finish date and respectively it should allocate to the standard weeks.

For desired result, look into the attachment.

[mohammadkhatimi]

gwassenaar‌

Plz help on this

[mohammadkhatimi]

stalwar1‌

plz help in this issue

[Gysbert_Wassenaar]

See attached qvw

[sunny_talwar · Accepted solution]

Can you see if this works

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

If(Round(Finish - WeekStart) <= 7, Round(Finish - WeekStart), Round(Weekend - Start)) - If(Round(Finish - WeekStart) <= 7, 0, RangeMax(Before(TOTAL Round(Weekend - Start)), 0)))

[mohammadkhatimi]

Can explain the logic plz...

[sunny_talwar]

Sorry for not being very helpful... but if you really want to understand, you can look at the values generated by each part of the expression to see what they show and why I used them

1) Weekend >= Start and WeekStart <= Finish

2) Round(Finish - WeekStart)

3) Round(Finish - WeekStart)

4) Round(Weekend - Start)

5) RangeMax(Before(TOTAL Round(Weekend - Start)), 0)

and then build it from there.... that is exactly what I did

[mohammadkhatimi]

yeah ur rite..i cn understand by this way..bt my concern was to understand ( - ) minus sign what indicate between two if condition