Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Calc for business days ahead or behind


FileSquire

Recommended Posts

Hello,

 

I'm trying to calculate how many business days ahead or behind a project is. Multiple design pages with five stages per, using scheduled and completed dates actually. I found this Scryptology calc for "work days".

 

Int[[End Date - Date] / 7] * 5 + Mod[End Date - Date, 7] - Case[DayofWeek[End Date]

 

This is a little funky if you enter a Saturday or Sunday. I know they are not business days in North America. Mainly I am having a brain cramp on getting accurate 'ahead' numbers. I was not able to locate this topic previously. Of course I did say I was cramping though.

Thanks for your consideration,

FileSquire

I'm getting a parenthesis warning on this post too. Have I been gone so long? 8-)

Link to comment
Share on other sites



×
×
  • Create New...

Important Information

Terms of Use