How Much Can I Borrow? Let Goal Seek Work It Out

Here’s a typical scenario we all face…you need a loan. You have a fixed interest rate and a fixed number of repayments. You can afford to pay back $200/month. So how much can you actually borrow? This video shows how Goal Seek will provide the...

How Many “Working” Days Until…

Today is May 1st 2013 (I know it’s not but for the purposes of this demo it is). The new system goes live on 1st October and user training has to be completed before this date. Training can only take place on Monday – Friday and in addition, there are...

Generating a List of Weekdays

I recently had 2 requests for help with generating a list of weekdays for the current year. In the first request, all that was required was a list of dates in column A and a list of days in column B. The second request was a bit more complex as the customer wanted to...