need help with my table

jbehl

New member
Joined
Jun 17, 2016
Messages
3
Reaction score
0
Points
0
Hi

So for the code I need to come up with I have a list of dates
in Column A are dates
in column B are the given values
in Column C are the the next days values minus one

so the issue I'm having is getting excel to do this for a calendar year. It needs to skip weekends and holiday values and use the next working days to get column C values.

-jbehl

View attachment 5141View attachment 5141
 
Top