Hi guys, Can I get Mid of the month to end of the month sales in every month using calculation

Hi Surya,

You could find the month's latest date and divide by 2, then round to the nearest whole number.

e,g,

Then add a flag to say whether the date is greater than this:

Please see attached workbook. If this post answers your question, please mark as best answer to help others find the solution.

Thanks,

Mavis