Weekday Calculation (missing SAT & SUN)

[Babylon5]

Good Evening, maybe its after a hard day and I am tired, but I can't fathom out how to create a list of days, that dont include Sat or Sun.

The Date to calculate the Days from is in $I$18

in cells $C61 onwards for th next 10 cells, $C70 I want to show the dates, missing out Saturdays and Sundays

So for example todays date in $I$18 is 15/11 (15th Nov), the sheet would show :-

$C61 would be 16th Nov
$C62 would be 17th Nov
$C63 would be 18th Nov
$C64 would be 19th Nov
$C65 would be 22nd Nov
$C66 would be 23rd Nov
$C67 would be 24th Nov
$C68 would be 25th Nov
$C69 would be 26th Nov
$C70 would be 29th Nov

I am currently using WEEKDAY, testing each cell to see if its a weekend then adding extra days, i.e. if its a Saturday add 2 days to make it a Monday, if its a Sunday add1 day ext, it works so far then becomes disruped into the second week, and also loses it if today is a Friday.

Can you help me out please ?

Many thanks

Rich

 

[Fluff]

How about

=WORKDAY($I$18,ROWS(C$61:C61))

 

[Babylon5]

How about

=WORKDAY($I$18,ROWS(C$61:C61))

Hi Fluff, thank you for the prompt reply, however that gives a #VALUE error ?

Cheers

Rich

 

[Fluff]

Check that the value in I18 is a real date & not text.

Also what version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Babylon5]

Check that the value in I18 is a real date & not text.

Also what version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Hi Fluff, MY MISTAKE, apologies !

I was referencing $I19 instead and now that I changed it, it works a treat, Many thanks

How does it work though ?, I understand the array counts up 1 to 10, but don't see why it misses out Sat & Sun - What Black Magic are you using ?

Many thanks, very much appreciated,

Rich

 

[Fluff]

What Black Magic are you using

Absolutely none, it's what the workday function (ie returns working days).

Please don't forget to update your account details to sow your version of Excel.