WORKDAY

  • Thread starter Thread starter riccifs
  • Start date Start date
R

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.
 
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

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
Click to expand...

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.
 
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.
 
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.
Click to expand...

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.
 
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

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
Click to expand...

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.
 
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.
 
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.
Click to expand...

I did it!
Many thanks again,

Bye,
Stefano.
 
Back
Top