| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate the number of days between two dates,missing weekends?
Hi,
I'm new at this!!! I want to calculate the number of days between a given date and todays date, but not counting weekends (and bank holidays!). Is this possible? My spreadsheet looks like this: <'=today' formula Date Received Todays date Number of days taken Days360= 20.11.06 08.12.06 14 18 24.11.06 08.12.06 10 14 30.11.06 08.12.06 6 8 04.12.06 08.12.06 4 4 Obviously Days360 formula by itself gives the number of days including weekends. Is there a way to nest a formula in this which will miss out none working days. I'm not great at this, so can the answer be in real simple step-by-steps!!! THANX |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate the number of days between two dates,missing weekends?
Lookup the NETWORKDAYS function in Excel Help. It does just what you
describe. (You'll need the Analysis ToolPak add-in activated to use that function). Post back with any questions. Does that help? *********** Regards, Ron XL2002, WinXP "littlejess22" wrote: Hi, I'm new at this!!! I want to calculate the number of days between a given date and todays date, but not counting weekends (and bank holidays!). Is this possible? My spreadsheet looks like this: <'=today' formula Date Received Todays date Number of days taken Days360= 20.11.06 08.12.06 14 18 24.11.06 08.12.06 10 14 30.11.06 08.12.06 6 8 04.12.06 08.12.06 4 4 Obviously Days360 formula by itself gives the number of days including weekends. Is there a way to nest a formula in this which will miss out none working days. I'm not great at this, so can the answer be in real simple step-by-steps!!! THANX |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate the number of days between two dates,missing weekends?
=NETWORKDAYS()
-- Brevity is the soul of wit. "littlejess22" wrote: Hi, I'm new at this!!! I want to calculate the number of days between a given date and todays date, but not counting weekends (and bank holidays!). Is this possible? My spreadsheet looks like this: <'=today' formula Date Received Todays date Number of days taken Days360= 20.11.06 08.12.06 14 18 24.11.06 08.12.06 10 14 30.11.06 08.12.06 6 8 04.12.06 08.12.06 4 4 Obviously Days360 formula by itself gives the number of days including weekends. Is there a way to nest a formula in this which will miss out none working days. I'm not great at this, so can the answer be in real simple step-by-steps!!! THANX |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number of days left in the Month? | Excel Discussion (Misc queries) | |||
| Calculate Number of Days Between Dates Minus Weekends | Excel Discussion (Misc queries) | |||
| Number of Days in the Month | Excel Discussion (Misc queries) | |||
| Formula to calculate number of days & ignore blank cells | Excel Discussion (Misc queries) | |||
| calculate the number of days from date received | Excel Worksheet Functions | |||
Linear Mode
