• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How can I input three days a week for forecasting?

B

bell407mech

New Member
Hello,

I am doing a forecasting on our helicopter fleet. One of our helicopter flies three days a week, Tuesday to Thursday. How can I make the formula work for this?

Thank you.
Pete
 
#1 Write any Tuesday date eg to cell F10
#2 for next day (Wed) add one - write for cell F11 =F10+1
#3 for next day (Thu) add one - write for cell F12 =F11+1
#4 for next day (Tue) add five - write for cell F13 =F12+5
#5 continue from #2
 
I am doing a forecast on a helicopter part. The helicopter flies three days a week. It flies 3.8 hours a day. Only on Tuesday, Wednesday, and Thursday.
The part now has 575.9 hours remaining to retirement. I need to know the forecast date to remove the part from the helicopter.
 
If you are open to a 'fancy' 365 formula, you could have
Code: 
= LET(
    daysRemaining, INT(hoursRemaining / flightHours∕day) - 1,
    finalFlight,   WORKDAY.INTL(today, daysRemaining, "1000111"),
    removalDate,   WORKDAY.INTL(finalFlight, 1, "0000011"),
    removalDate
  )
1. The days remaining is rounded down to avoid running out of hours mid-flight
2. The last date for the final flight is calculated on the basis of a 3 day week
3. The removal date is taken to be the first weekday following the final flight

Note: The defined name 'flightHours∕day' uses a unicode division symbol that is not the '/' that Excel uses for arithmetic division
 
You must log in or register to reply here.
Back
Top