How to calculate the number of business days between created date column and todays system date?

Mariel016the formula is shown below and assumes that the day the item was created is the first working  day. If you don't want the first day counted you'll need to remove the +1. As you'll see in the image, those items created yesterday on 19 April (a Saturday) result in 0 working days.

=IF(ISERROR(DATEDIF(Created,Today(),"d")),"",(DATEDIF(Created,Today(),"d"))+1-INT(DATEDIF(Created,Today(),"d")/7)*2-IF((WEEKDAY(Today())-WEEKDAY(Created))<0,2,0)-IF(OR(AND(WEEKDAY(Today())=7,WEEKDAY(Created)=7),AND(WEEKDAY(Today())=1,WEEKDAY(Created)=1)),1,0)-IF(AND(WEEKDAY(Created)=1,(WEEKDAY(Today())-WEEKDAY(Created))>0),1,0)-IF(AND(NOT(WEEKDAY(Created)=7),WEEKDAY(Today())=7),1,0))

But be aware that the value in calculated column is actually static and does not update dynamically. It's only updated when the item is edited. For dynamic updates you need to use JSON column formatting.

Rob
Los Gallardos
Microsoft Power Automate Community Super User
Global Power Platform Lead, WSP (and classic 1967 Morris Traveller driver)