|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 11th, 2010, 03:09 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate days help
I am needing to calculate dates. What I need to accomplish, is according to
a school calendar, which has weekends, holidays and other specified dates off from school, what would be say the 50 day from today excluding the weekends, holidays and spring breaks? Can networkdays or other options within excel help me out? 
|
|
#2
February 11th, 2010, 03:27 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate days help
Take a look NETWORKDAYS function in help menu
"Kim K" wrote: I am needing to calculate dates. What I need to accomplish, is according to a school calendar, which has weekends, holidays and other specified dates off from school, what would be say the 50 day from today excluding the weekends, holidays and spring breaks? Can networkdays or other options within excel help me out?
|
|
#3
February 11th, 2010, 03:39 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate days help
You want:
=workday(a1,50,c1:c20) Where a1 is your start date, and c1:c20 are your list of holidays and days off Regards, Fred "Kim K" wrote in message ... I am needing to calculate dates. What I need to accomplish, is according to a school calendar, which has weekends, holidays and other specified dates off from school, what would be say the 50 day from today excluding the weekends, holidays and spring breaks? Can networkdays or other options within excel help me out?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
