Recent content by spywgc
-
S
Calc Days to/past Target date - Problem
These are the functions that someone posted on here.I have a Holidays dbase & table. I run Workdays function. I have a target completion date for a deivery and I need to record how many working days (exclude weekends and Bank hols) between the actual delivery and the target date. It should be...- spywgc
- Post #6
- Forum: Modules & VBA
-
S
Calc Days to/past Target date - Problem
Sorry - I should have added that I've not much experience at this level of VBA. It would really help if someone could show me an example. Thanks again- spywgc
- Post #3
- Forum: Modules & VBA
-
S
Calc Days to/past Target date - Problem
I've searched the forum at length & tried many variations on the theme but none seem to work for me. I need to measure how many days early or late a date is compared to a Targer date. It must exclude weekends and UK Bank Hols. There are many functions here that will work if the date is before...- spywgc
- Thread
- Replies: 6
- Forum: Modules & VBA
-
S
Calculate days to/past a date excluding Bhols & weekends
I need to calculate the number of days excluding BankHols (UK) and Weekends before or after a Target date. Dates after the Target date should be negative. I have found many functions on this forum but they all return a positive number even if the End date is after the Target date. Any help...