WORKDAY

[riccifs]

Hi to everyone in the N.G.,
I'm using the WORKDAY function in a cell.
In the cell A1 I wrote a date and in the cell B1 I insert a function
like this =WORKDAY(A2;10)
It's working fine but what I'd like to apply the function to all the
cell in the column B.
I tired this syntax =WORKDAY(A2:A50;10) but it does not work.
How can I do that?

Many thanks,
Stefano.

 

[Roger Govier]

Hi

You will need to copy the formula down column B
make the formula in B2
=IF(A2="","",WORKDAY(A2;10))
and copy down through B3:B50
If you want to "fix" the values after calculating, then copy B2:B50 and
Paste Special>Values

 

[riccifs]

Hi

You will need to copy the formula down column B
make the formula in B2
=IF(A2="","",WORKDAY(A2;10))
and copy down through B3:B50
If you want to "fix" the values after calculating, then copy B2:B50 and
Paste Special>Values

Hi Roger,
thanks to answered me
I'm trying it but it doesn't seems to work to me.
I having #NAME? problems where I'm making mistake?

Bye,
Stefano.

 

[David Biddulph]

If you look in Excel help for the WORKDAY function it will tell you what to
do if you get the #NAME? response.

I notice that Roger's formula seems to have a mixture of commas and
semi-colons so you may need to adjust for whatever regional settings you
have for your list separator.

 

[riccifs]

If you look in Excel help for the WORKDAY function it will tell you what to
do if you get the #NAME? response.

I notice that Roger's formula seems to have a mixture of commas and
semi-colons so you may need to adjust for whatever regional settings you
have for your list separator.

Hi David,
my regional setting is Italian, what do you think I have to change?
May be , with ; or what?
Do you think the function should work properly as it is wrote?

Bye,
Stefano.

 

[Roger Govier]

Hi

David quite rightly pointed out that I had used commas when wrapping your
formula in an IF (Statement)

Try
=IF(A2="";"";WORKDAY(A2;10))

As far as the #NAME error is concerned, Workday is part of the Analysis
Toolpak.
Tools>Addins>check the box for Analysis Toolpak

 

[riccifs]

Hi

David quite rightly pointed out that I had used commas when wrapping your
formula in an IF (Statement)

Try
=IF(A2="";"";WORKDAY(A2;10))

As far as the #NAME error is concerned, Workday is part of the Analysis
Toolpak.
Tools>Addins>check the box for Analysis Toolpak

Hi Roger,
your last function is working right, many thanks for your help!

Let me ask you one more thing please.
I was trying to apply a conditional formatting to the cell(s) where I
copied your formula, because I'd like to make change them green if
their date reach the today date.
I insert that condition in the conditional formatting dialog box
=B1<=TODAY().It's work but how can I extent it to the full column?
I mean, what I'd like to do is formatting a rage of cell in a column B
so every time its date past the today date its color change to green.

Thanks again I really appreciate your help!
Bye,
Stefano.

 

[Roger Govier]

Hi Stefano

mark Column B, then got Format>Conditional Formatting and enter your
formula.
Provided you use B1, and not $B$1 it will be treated as relative, and will
adjust it is applied to successive rows down the column.

 

[riccifs]

Hi Stefano

mark Column B, then got Format>Conditional Formatting and enter your
formula.
Provided you use B1, and not $B$1 it will be treated as relative, and will
adjust it is applied to successive rows down the column.

I did it!
Many thanks again,

Bye,
Stefano.