| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting Days of The Week Only In a Formula
Hi:
I was hoping that someone could tell me if possible to add only week days to a formular. By this i mean for example; cell A1 (Start date (Thursday)) has 1-Jan cell A2 (number of working days) has 10 cell A3 (End date) should be 14-Jan not 11-Jan Thanks in advance Regards: Bruno |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Counting Days of The Week Only In a Formula
Take a look at the WORKDAY() function in Help (it's an Analysis Toolpak
Add-in - choose Tools/Add-ins). In article , "Bruno" wrote: I was hoping that someone could tell me if possible to add only week days to a formular. By this i mean for example; cell A1 (Start date (Thursday)) has 1-Jan cell A2 (number of working days) has 10 cell A3 (End date) should be 14-Jan not 11-Jan |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Counting Days of The Week Only In a Formula
Hi
=WORKDAY(A1,A2) in A3 -- Regards Frank Kabel Frankfurt, Germany Bruno wrote: Hi: I was hoping that someone could tell me if possible to add only week days to a formular. By this i mean for example; cell A1 (Start date (Thursday)) has 1-Jan cell A2 (number of working days) has 10 cell A3 (End date) should be 14-Jan not 11-Jan Thanks in advance Regards: Bruno |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Days of the Week | Excel Worksheet Functions | |||
| Counting Days of Week | Excel Discussion (Misc queries) | |||
| Counting Days of Week in Date Ranges | Excel Worksheet Functions | |||
| Re Change 5 week days to 7 days in this formula | Excel Worksheet Functions | |||
| selecting days of week using a formula in spreadsheets | Excel Worksheet Functions | |||
![Bruno[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
