Hello all,
I will try to keep this as short an concise as possible.
I am trying to determine the age of invoices. I am using the NETWORKDAYS.INTL function
At our company, invoices do not start aging until the day after they are signed. So if it is signed 10/14/15, day 1 is actually 10/15/15
In the A column I have the start date
In the B column I have the end date
For some reason, it is returning invoices closed on the same day with a value of -2
this is the formula being used =NETWORKDAYS.INTL(B2+1,C3,"0000000",)
Any Ideas?
P.s. all days count and there are no holidays.
Thanks.
I will try to keep this as short an concise as possible.
I am trying to determine the age of invoices. I am using the NETWORKDAYS.INTL function
At our company, invoices do not start aging until the day after they are signed. So if it is signed 10/14/15, day 1 is actually 10/15/15
In the A column I have the start date
In the B column I have the end date
For some reason, it is returning invoices closed on the same day with a value of -2
this is the formula being used =NETWORKDAYS.INTL(B2+1,C3,"0000000",)
Any Ideas?
P.s. all days count and there are no holidays.
Thanks.