Timthetoolman
New Member
- Joined
- Jan 8, 2014
- Messages
- 2
Gday all,
I am relatively inexperienced with VBA, but not too bad with excel, and I am trying to create a holiday leave sheet for my company. I am using Excel 2013
I cannot attach anything yet, but am happy to email a test sheet with actual leave applications.
I have used the networkdays function to calculate the days between two dates (A9:B9), in C9, and then a simple sum to add all the days for annual leave in the resulting c column.
What I need to come up with is a function or something to add all the days in column A, if the corresponding date in column A is before today's date.
Essentially adding all the days actually taken, and not the future dated ones.
Any help or advice would be great.
Tim
I am relatively inexperienced with VBA, but not too bad with excel, and I am trying to create a holiday leave sheet for my company. I am using Excel 2013
I cannot attach anything yet, but am happy to email a test sheet with actual leave applications.
I have used the networkdays function to calculate the days between two dates (A9:B9), in C9, and then a simple sum to add all the days for annual leave in the resulting c column.
What I need to come up with is a function or something to add all the days in column A, if the corresponding date in column A is before today's date.
Essentially adding all the days actually taken, and not the future dated ones.
Any help or advice would be great.
Tim
Last edited: