How to calculate days based on nonstandard month start and end

[#1]

I have a service group that needs to track their time spent with clients between the 21st of the prior month to the 20th of the current month.  Any ideas on how I would go about doing that?

Thanks very much.

[sunny_talwar]

You are trying to know the days between two dates? or working days?

If it is days -> EndDate - StartDate

If it is working days -> NetWorkDays(StartDate, EndDate)

[#3]

Hi Sunny,

Thank you for the reply.  I am not trying to calculate the number of days.

For example, for any given non-standard month (21st to 20th), I need to know how may days I have remaining in the non-standard month.  For instance, today, the 19th, I have one day remaining in the NS month.

So, when I'm calculating the total time spent per worker, I need to be looking at all the work that they have completed between the 21st of last month and today.

Hopefully, that makes it a little clearer.

Thanks again!

[sunny_talwar]

Can you share what you have today? Script to create the non-standard calendar and may be one of us here can take it forward