hi
you might try the =networkday function
=NETWORKDAYS(TODAY(),A1)
you can sub a1 for today() and change the other cell to a2.
you can also skip holidays too
=NETWORKDAYS(TODAY(),A1, holiday range)
where holiday range is a range that contains all of your
holidays.
-----Original Message-----
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
.
|