Reg: Calender(want week except sundays)

[#1]

Hi All,

I want week except sundays,

i.e., monday - monday = 7 days (bcoz dnt want sunday) 1st week

tuesday - tuesday= 7 days, 2nd week ............

let me knw Is this possible

Thanks in advance,

[suniljain]

pls check networkday function . it will give you week day between particular date range

[johnw]

One way is to create a calendar with a weekday in it, then use set analysis to count the number of dates other than Sunday in the given range.

count({1<Weekday-={'Sun'},Date={">=$(vFrom) <=$(vTo)"}>} distinct Date)

See attached. That won't work if your two dates are part of a chart, but I really don't know what you're after here.