forumla

[VbaHell]

Hello all

I hope you can help on this one

I want to work out what the cycle dates should be but not to include a Sat or Sun in the dates

A1 cell value will be a date
B1 cell value wll be the frequency per year
C1,D1,E1 etc would be the dates

Example

"A1" = 9/1/2018
"B1" = 1
"C1" = 9/1/2018

"A1" = 9/1/2018
"B1" = 12
"C1" = 9/1/2018
"D1" = 9/2/2018
"E1" = 9/3/2018
"F1" = 9/4/2-18
"G1" = 9/5/2018
"H1" = 11/6/2018 (This is because the 9th falls on the Saturday so the next availabe week day date is the 11th)

I am looking for some VBA code that will automate this and populate all the cells once after "A1" and "B1" values are entered. Maximum frequency is 52 (Weeks)

Any help would be great please

 

[VbaHell]

I agree but I have to try and equally space out the date over the 12 month period which really complicates this

 

[shg]

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]

A​

[/td][td="bgcolor:#C0C0C0"]

B​

[/td][td="bgcolor:#C0C0C0"]

C​

[/td][td="bgcolor:#C0C0C0"]

D​

[/td][td="bgcolor:#C0C0C0"]

E​

[/td][td="bgcolor:#C0C0C0"]

F​

[/td][/tr][tr][td="bgcolor:#C0C0C0"]

2​

[/td][td]

Mon 01 Jan 2018​

[/td][td]

4​

[/td][td="bgcolor:#E5E5E5"]

Mon 01 Jan 2018​

[/td][td="bgcolor:#E5E5E5"]

Mon 02 Apr 2018​

[/td][td="bgcolor:#E5E5E5"]

Mon 02 Jul 2018​

[/td][td="bgcolor:#E5E5E5"]

Tue 02 Oct 2018​

[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

3​

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

91​

[/td][td]

91​

[/td][td]

92​

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


Those look evenly spaced to me.

 

[VbaHell]

I am very sorry you are correct

Thanks for supporting me on this as you will my me look like a superstar in front of my boss

Cheers

 

[shg]

Well, go us!

You're welcome.

BTW, a formula would do equally well.