getting Values to correspond with dates

[jbehl]

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.

 

[FDibbins]

Hi, welcome to the forum

Try this...

	A​
1​	Friday, January 01, 2016​
2​	Monday, January 04, 2016​
3​	Tuesday, January 05, 2016​
4​	Wednesday, January 06, 2016​
5​	Thursday, January 07, 2016​
6​	Friday, January 08, 2016​
7​	Monday, January 11, 2016​
8​	Tuesday, January 12, 2016​
9​	Wednesday, January 13, 2016​
10​	Thursday, January 14, 2016​
11​	Friday, January 15, 2016​
12​	Monday, January 18, 2016​
13​	Tuesday, January 19, 2016​

A2=WORKDAY(A1,1)
copied down

I know that was not exactly what you want, but you should be able to modify to suite

 

[jbehl]

Hi Ford

I have down this but my numbers are still not calculating the way i want them too
for instance
I have values in Friday Jun 17,2016 Start value 5 End Value (one box lower)-1
The problem is i cannot not get excel to omit the holidays and weekends when do this function
The end Value needs to be the next working day - 1 and I cant get excel to do it for me
Can you help?

-jbehl