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

  • Thread starter Thread starter ~Alan
  • Start date Start date
A

~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
 
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
 
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
 
Also I have used named ranges before is there any peticalar format that should
be used?
 
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))
 
You say you named the range -- holiday
but the formula refers to -- holidays
 
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))
Click to expand...

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
 
Back
Top