"Weeks till vacation" calculation
I'd like some guidance with the following calculation.
I'd like to be able to calculate the "weeks to go" for a particular due date. Think of it as a count down to a particular date using the current date as the start date. I'd like the result shown as a decimal. Each day of the week would have a value of .2, only weekdays would be counted. For example, a week and three days would be expressed as 1.6 weeks and four days until the due date would be .8 weeks.
Any help would be greatly appreciated.