Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
have a look at NETWORKDAYS (the Analysis Toolpak has to be installed for this) and use =NETWORKDAYS(A1,A2,holiday_list_if_required) -- Regards Frank Kabel Frankfurt, Germany OSCAR wrote: Guys. In A1 i have to enter the date of delivery, A2= Today() and in A3 I need to have the number of working days since the date of delivery(No weekends). Lets say: A1 B1 C3 03/29/04 04/09/04 10 days Is this possible? Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Working with Dates | Excel Discussion (Misc queries) | |||
Working with dates | Excel Discussion (Misc queries) | |||
Working with dates | Excel Worksheet Functions | |||
working with dates | Excel Worksheet Functions | |||
working with dates | Excel Discussion (Misc queries) |