AnsweredAssumed Answered

"Weeks till vacation" calculation

Question asked by shogun on Dec 14, 2008
Latest reply on Dec 15, 2008 by shogun


"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.

Thank you.