=IF(L8+1>TODAY(),"",L8+1) to skip weekends and holiday

[~Alan]

XL2000
Is there some way to do this is a sheet code?

1. How can I get this formula =IF(L8+1>TODAY(),"",L8+1) to skip weekends
and holidays in the column
2. How can I get this formula =IF(L8+1>TODAY(),"",L8+1) to skip every
other cell in the column
3. When using contitional formating how would you copy an image like a
green or black star

 

[Bob Phillips]

Alan,

1. Use the Workday function, e.g.
=IF(WORKDAY(L8,1,holidays)>TODAY(),"",WORKDAY(L8,1,holidays))
where holidays is a named range that contains the holiday dates
2. don't understand.
3. CF can only set a format, font or cell, it cannot insert a picture

 

[~Alan]

2.don't understand.
2.How can I get this formula =IF(L8+1>TODAY(),"",L8+1) to skip every other
cell in the column
as in c5 c7 c9 c11 c13
and not c5 c6 c7 c8 c9 c10
can CF Copy from a cell as in =IF$Hh8>0copyGG22" or somthing like that

 

[~Alan]

Also I have used named ranges before is there any peticalar format that should
be used?

 

[~Alan]

I am getting an error #NAME?
I defined a name range holiday and inserted the dates any suggestions

=IF(WORKDAY(L8,1,holidays)>TODAY(),"",WORKDAY(L8,1,holidays))

 

[Debra Dalgleish]

You say you named the range -- holiday
but the formula refers to -- holidays

 

[Ron Rosenfeld]

I am getting an error #NAME?
I defined a name range holiday and inserted the dates any suggestions

=IF(WORKDAY(L8,1,holidays)>TODAY(),"",WORKDAY(L8,1,holidays))

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

How?

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then click
OK.
If necessary, follow the instructions in the setup program.


Also, make sure your Holidays range is named the same in the formula (above you
have one named holiday, but in the function you wrote holidays.


--ron