only show workdays in a cell

B

Bazza

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
 
P

Peo Sjoblom

Look in help for NETWORKDAYS, also no need to sum, =A2-A1 will do
or if you want to save space

=A2-TODAY()

However using networkdays

=NETWORKDAYS(TODAY(),A2,Holidays)

where Holidays in this example is a named range that holds public holidays
but can also be a regular range like H2:H12 for instance

NETWORKDAYS is part of the Analysis ToolPak add-in that comes with excel,
if not installed at first time have the office/escel cd handy, check it
under tools>add-ins and follow the instructions


Regards,

Peo Sjoblom
 
G

Guest

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.
 
Top