Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to calculate last 60 business days from today()-1. Business days exclude Saturdays and Sundays. The below script does work for 60 calendar days. But how do I make it work for 60 business days?
Let vMaxDate = Date(today()-1);
Let vMinDate= Date(vMaxDate-60);
Please help.
Regards,
Ram
Dont you want to calculate MaxDate minus 12 weeks?
Then you could use Date($(vMaxDate)-84)
Thats also the same as 60 working days.
I think this expression will help you.
Date(today()-1)
Date(vMaxDate -83),
from today to calculate exactly 60 business days means 7 weeks which is 84 so that i have taken 83 for calculate from yesterday.
and to extract working 60 business days used Network days function.
Please like and accept the solution if u liked it.