| 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 |
| 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 | |||
Threaded Mode
