billieclap
Technical User
Hello, re Excel 97 or if possible Access 2000
I have been trying to calculate the date 40 CALENDAR days after a given date, and then go to the next Fridays date. This is complicated by a range of dates that can not be included in the count(a named range of dates or a table, Table1, field1 which has the excluded dates listed)and unfortunately the dates in the named range are not always weekends. "Networkdays" is similar but it does not calculate calendar days. Any assistance will be greatly appreciated, THANK YOU in advance Bill
I have been trying to calculate the date 40 CALENDAR days after a given date, and then go to the next Fridays date. This is complicated by a range of dates that can not be included in the count(a named range of dates or a table, Table1, field1 which has the excluded dates listed)and unfortunately the dates in the named range are not always weekends. "Networkdays" is similar but it does not calculate calendar days. Any assistance will be greatly appreciated, THANK YOU in advance Bill