Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=networkday('15/1/2018', '24/1/2018')
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
Hi Sandip
Use networkdays($(vDate),$(vDate)+(vRange)).
Please let us know the feedback.
Thanks
CY
then maybe some tink like this
count({<Date=WeekDay(vDate)>}vRange))