in the example using superstore data
I have done it in 2 parts - this finds the first of the month
then this will adjust for the workweek assuming the week starts on Sunday
it returns this
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.
Thank you, very much for your logic
Can you please share the workbook that you have referred asap.
I am getting some error while doing calculated field .So, i can refer your workbook
Thank you, very much for your response.
Could you please review this link : Filter Selection issue--Year and its corresponding month selection issue if possible as you are expert in manipulating dates.