Calculate the exact age of a referral based on date and time it was received

Hi everyone,

I am trying to create a spreadsheet that monitors SLAs that allows to identify the age of a referral based on the specific date and time it was received. The formula I have at the minute calculates the age based on the date but even the age is incorrect as it is showing something that was received yesterday i.e. 22/09/2021 as being on day 2 but in reality it would be on day 1. What I need is for something to be received 22/09/2021 09:00 as showing as day 1 from 23/09/2021 09:00 until 24/09/2021 08:59 when it would then update to day 2 at 24/09/2021 09:00 (the timer starts as soon as the referral is received). Please can somebody help with this?

=IF(I2="Pending",NETWORKDAYS(A2,TODAY(),Dates!$D$2:$D$1000))

The formula incorporates bank holiday dates as the timer stops over the weekend/bank holiday.

Apologies, it should be attached now?

I agree with Ali we really need expected results, but if you are bothered about the time in the day perhaps
=IF(C2="Pending",NETWORKDAYS(A2,TODAY(),Dates!$D$2:$D$1000)-1+(MOD(NOW(),1)>MOD(A2,1))*1,"")

losing a day as you wish the same day -1
then adding a day if the time that it is now > than the time the request was received

If 9:00 AM is the cut-off time, then modifying from davsth's formula:
=IF(C2="Pending",NETWORKDAYS(A2,TODAY(),Dates!$D$2:$D$1000)-1+(9/24>MOD(A2,1))*1,"")

Apologies for my delayed response, I have tested the formulas provided and there doesn't appear to be any change in line with what's expected. I have attached an updated version of the sample spreadsheet with my original formula which now includes the expected result. I have added a comment on each expected result to explain why it should be like that to make it make more sense. If there is anything else I've missed please let me know and I'll look to provide it - I'm new to this sort of thing.

Entered cell A1 as date/time, formula for cell D3=IF(C3="Pending",NETWORKDAYS(A3,$A$1,Dates!$D$2:$D$1000)-1-IF(MOD(A3,1)>MOD($A$1,1),1,0),"").

Change cell A1 to =NOW() to reflect current date/time.