You can set your worksheet up like this and put a count of distinct dates in the table. You can see that this data source does not have data for every single day. So this counts the number of dates for which there were orders, not total calendar days.
If you need total calendar days, I have included in the attached workbook a data source that is essentially a date table. It has all dates from 1980 to 2030.
Hope this helps,
Dates.twbx 1.4 MB
please see the attached approach
I used a data set that I keep called date ladder - it is just a list of dates - you could use any dataset
it returns this
you don't need a special calculations just use the weekday and month/year options on the date field
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
count the dates_v10.2.twbx 36.0 KB
Thank you! This worked also!
Thank you! This worked!!!