Hello, I have an existing formula that copies the entries in one column to the next column. These columns represent days of the month. What I need is for the formula to skip weekends and holidays. Here is the current formula: =IF(OR(L802="",M802="",COUNTA(L3:L799)=0),"","→")
Formula is entered on line 801 for each day of the month, below is the first day
L802 is the first day of the month
M802 is the next day of the month
L3:L799 is the range for the data
The way the formula works is if data is entered in column L3:L799 then in cell L801 an arrow → is placed in the cell. When the user wants to copy the entries from day one to the next they would click on the →. This process continues through the end of the month. I now have a situation where I need the coping from one day to the next to skip over weekends and holidays. Below is another formula I use that I think is part of the solution but I don't know how to make it work. =IF(WORKDAY(EOMONTH($L$802,0)+1,-1,holidays)<o
></o>
Thanks for any help you guys can provide
Formula is entered on line 801 for each day of the month, below is the first day
L802 is the first day of the month
M802 is the next day of the month
L3:L799 is the range for the data
The way the formula works is if data is entered in column L3:L799 then in cell L801 an arrow → is placed in the cell. When the user wants to copy the entries from day one to the next they would click on the →. This process continues through the end of the month. I now have a situation where I need the coping from one day to the next to skip over weekends and holidays. Below is another formula I use that I think is part of the solution but I don't know how to make it work. =IF(WORKDAY(EOMONTH($L$802,0)+1,-1,holidays)<o
></o>Thanks for any help you guys can provide
