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...
[Table="width:, class:grid"][tr][td] [/td][td]

A​

[/td][/tr]
[tr][td]

1​

[/td][td]

Friday, January 01, 2016​

[/td][/tr]

[tr][td]

2​

[/td][td]

Monday, January 04, 2016​

[/td][/tr]

[tr][td]

3​

[/td][td]

Tuesday, January 05, 2016​

[/td][/tr]

[tr][td]

4​

[/td][td]

Wednesday, January 06, 2016​

[/td][/tr]

[tr][td]

5​

[/td][td]

Thursday, January 07, 2016​

[/td][/tr]

[tr][td]

6​

[/td][td]

Friday, January 08, 2016​

[/td][/tr]

[tr][td]

7​

[/td][td]

Monday, January 11, 2016​

[/td][/tr]

[tr][td]

8​

[/td][td]

Tuesday, January 12, 2016​

[/td][/tr]

[tr][td]

9​

[/td][td]

Wednesday, January 13, 2016​

[/td][/tr]

[tr][td]

10​

[/td][td]

Thursday, January 14, 2016​

[/td][/tr]

[tr][td]

11​

[/td][td]

Friday, January 15, 2016​

[/td][/tr]

[tr][td]

12​

[/td][td]

Monday, January 18, 2016​

[/td][/tr]

[tr][td]

13​

[/td][td]

Tuesday, January 19, 2016​

[/td][/tr]
[/table]
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