only show workdays in a cell
 

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

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 toolsadd-ins and follow the instructions


Regards,

Peo Sjoblom


"Bazza" wrote:

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

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

.