Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
For Example,
April 2016 has 30 days and 5 Saturdays.
I want to count only those 5 Saturdays,even if they aren't passed.
For instance today is(4th Apr 2016) Still the count should be 5 Saturdays.
This should work for every month.
Regards,
Mohammad
I dont have the data for the future saturdays that's the main problem.
Kindly help me with this issue... for the future saturdays only for the current month.
I want to do this in the master calendar. My date is linked with Master Calendar, so the data wont be there for future dates.
So I want the solution which will help me to count the saturdays.. which are not present in the dates.
Ok, but could you clarify why my suggested expression using Div() is not working for you?
For example, if you are using a SalesDate field and what to get the number of saturdays in the month the SalesDate is located in, you should be able to use something like
=Div(WEEKDAY(Monthstart(SalesDate)-6)+1-Monthstart(SalesDate)+Floor(MonthEnd(SalesDate)),7)
[Used e.g. in an expression in a chart with dimension SalesDate, or in a text box with a single SalesDate selected. Use aggregation functions like Max() around SalesDate when there are multiple SalesDate in the record set of your expression's scope]
Maybe you can just post some sample records with your expected results to understand better what your issue is.
You need to create the Future dates
It was answered in this previous post :
Thank you...
on behalf of the nhs thanQ for sharing for free ...