AnsweredAssumed Answered

"Weeks till vacation" calculation

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

Title

"Weeks till vacation" calculation

Post

Hello-

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.

Outcomes