so i am a vba beginner (I was thrown into this last week) i understand certain things but not many so I need help tutorial style haha
so i need to code something that relates to this if then statement
if our value in column E (row start) is on a weekend or holiday then our value in column F (row end) will use the next working day to caluculate a value
ie this table that i just made up
let me know if you need more clarification on the problem
so i need to code something that relates to this if then statement
if our value in column E (row start) is on a weekend or holiday then our value in column F (row end) will use the next working day to caluculate a value
ie this table that i just made up
| D | E | F |
| date | row start | row end (x-1) |
| Wednesday 06/29/2016 | 12 | 12 |
| Thursday 06/30/2016 | 13 | 11 |
| Friday 07/01/2016 | 17 | 8 |
| Saturday 07/02/2016 | 0 | 0 |
| Sunday 07/03/2016 | 0 | 0 |
| Monday 07/04/2016 | 0 | 8 |
| Tuesday 07/05/2016 | 9 | 9 |
| Wednesday 07/06/2016 | 10 | 18 |
| Thursday 07/07/2016 | 19 | - |
let me know if you need more clarification on the problem