Counting Days of The Week Only In a Formula

  • Thread starter Thread starter Bruno
  • Start date Start date
B

Bruno

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
 
Take a look at the WORKDAY() function in Help (it's an Analysis Toolpak
Add-in - choose Tools/Add-ins).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Day of Week 2
Count the highest number of days without “errors” 2
No of Days between two dates and offset formula 4
excel sumproduct formula 3
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Formatting date as first letter of day only 33
Copy tab from one spreadsheet to multiple tabs in another spreadsheetwhile retaining the targets spr 15
Excel Excel: sum of 7 cells (weeks) in every row of a spreadsheet 1

Back
Top