how can i calculated the number of a weekday in a date range?

[ananyaghosh]

Hi,

I have created a date filed and assign the value to a variable vDate and I have a date range also and assign the value to a variable vRANGE. Now if the use select vDate as 24/1/2018 and range as 9, the I have calculate the number of Wednesday which is actually the creation date in that range.

SO if vDate is 24/1/2018 and vRange is 9, the the date range is 15/1/2018 To 24/1/2018 and I need to calculate how many weekday is in between in that date range. in this case the weekday is Wednesday as because 24/1/2018 is Wednesday.

so any idea will be appreciated.

Thanks,

Sandip Ghosh

[zebhashmi]

=networkday('15/1/2018', '24/1/2018')

[ananyaghosh]

it will give me the date difference between 2 dates, but I want to know the number of Wednesday in between 2 days.

Thanks,

Sandip

[ychaitanya]

Hi Sandip

Use networkdays($(vDate),$(vDate)+(vRange)).

Please let us know the feedback.

Thanks

CY

[zebhashmi]

then maybe some tink like this

count({<Date=WeekDay(vDate)>}vRange))