Excel bods

[Maccapacca]

I'm having trouble with this

In C3 add C2 to B3 but use workday/network day, it works if you use (B3,6) but I want to be able to manipulate C2 for other trades over 400 apartments.

I've tried =WORKDAY(B3+$C$2) but I just get a too fewer error

Help

 

[WillyNelson]

=WORKDAY(B3,C2)

Syntax is (start_date , number_of_days) so if you do (B3+C2) you're asking the start date to be 10/03/15 and not putting number_of_days in

 

[The Dread Pirate]

So you want the date and either workday or Network day in there so the cells content would read:

Workday 17/03/2015 or Network day 17/03/2015?


Just trying to clarify as you've not been that forthcoming with what you expect?

 

[MichaelAwkward]

^Yeah.

=WORKDAY(start date, days, holidays).

B3+$C$2 doesn't make any sense.

 

[The Dread Pirate]

So you want the date and either workday or Network day in there so the cells content would read:

Workday 17/03/2015 or Network day 17/03/2015?


Just trying to clarify as you've not been that forthcoming with what you expect?

Oh you're using the function My bad for just glancing at it

 

[Maccapacca]

=WORKDAY(B3,C2)

Syntax is (start_date , number_of_days) so if you do (B3+C2) you're asking the start date to be 10/03/15 and not putting number_of_days in

Excellent

Works a treat now, I have 15 trades and 400 properties and no one here uses Project so I have to butcher it into Excel

Thanks