Count Work Days between dates

Excel has a formula called "NETWORKDAYS" that can be used to count the number of weekdays (Monday-Friday) between two dates (excludes Sat and Sun). Is there a similar formula or group of formulas that can be used together to accomplish this same calculation?

Parents

0 Rolustech Support over 5 years ago

Hi Liana,
There is no built in formula in Sugar for this. However you can implement this logic in a before or after save hook depending on your requirement. There is a custom function for PHP that can help you achieve this. You will find it on this link https://stackoverflow.com/questions/336127/calculate-business-days

The function expects a start and an end date.

Regards,
Rolustech Support
www.rolustech.com
support@rolustech.com
Cancel
Vote Up +2 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Rolustech Support over 5 years ago

Hi Liana,
There is no built in formula in Sugar for this. However you can implement this logic in a before or after save hook depending on your requirement. There is a custom function for PHP that can help you achieve this. You will find it on this link https://stackoverflow.com/questions/336127/calculate-business-days

The function expects a start and an end date.

Regards,
Rolustech Support
www.rolustech.com
support@rolustech.com
Cancel
Vote Up +2 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data