Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
show macro security setting in a cell | Excel Worksheet Functions | |||
Show a time from one calculated cell as a decimal in another cell. | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
cell reference show cell name (ie. D45) and not cell value | Excel Worksheet Functions |