Hi all,

I'm currently trying to set up a sheet to make my life at work a bit easier.

When setting up a Direct Debit There are 3 options, the 7th, 17th and 27th. I've put these into a drop down list. I need this list to be slightly dynamic. I must allow 10 working days from the date of the arrangment before I can apply the DD.

To explain further. If someone were to want to set up a DD and spoke to me today. If they then requested the DD be taken on the 17th, I wouldn't be able to set it up until the 17th of next month as 10 working days are required. I'd like the list to reflect this. I can do it in OO with a simple if / switch but excel is a strange creature and I'm not sure how to approach the problem.

From that I think I also need to calculate the number of weeks remianing in the current financial year. I think I should be able to do this by using the Today() function and some maths.

Thanks for any and all help.