Hi Guys,
I need help in developing a formula to calculate days between two dates that’s falling in a particular month.
For Example - I am working on task for 3 hrs a day that started on 8th Mar 2020 and continued till 12th Jun 2020. I want to calcula...
Hey Guys, I went through this again and was able to resolve the to some extend.
I am yet to validate all the results, but here is the solutions that I created:
IF(
{Start Date}>'2020-03-31',
0,
IF(
{Start Date}<'2020-03-01',
IF(
{End Date}<...
