If I am adding records in to a spreadsheet, I want it to count the number of
days that record has been on the spreadsheet for.

For example I am currently using the code =TODAY() but this also includes
weekends.

So when if =TODAY() is in A1

The date I am entering the record is in A2

=sum(A1-A2)

This works well but once it comes to Thursday and Friday it starts to count
the weekends as well giving an in accurate reading.

Please can someone help me

Thanks