Thank you! That's really helpful. Are you able to look at a similar calculation for the compound interest starting at an initial 10k?
Hi, would someone be able to look at this request for me and help me with the formula for it? Thanks Andy
Hi Sunny/all, I'm looking for some help in the attached spreadsheet to calculate holiday entitlement for my employees. I'm looking to have this calcul...
Hi Sunny, just got a formula I've been trying to create but haven't been quite able to do it. Are you able to help? See attached. Thanks Andy
Hi Sunny, that works perfectly! Thank you so much for your help! Andy
Hi Sunny, the formula's all work fine, thanks. The only logical thing that won't work with the current formula's is if (for example), the staff mem...
Hi Sunny, are you able to help me with this amendment to a previous excel you developed for me. See comments box inside. Thanks Andy
Thanks Sunny. Separately, I'm looking to insert a macro/button in the database which returns the user to the latest spreadsheet based on a given da...
Hi Sunny, yes, precisely this. Reason being, if the wage rate increases during the year, I don't want the previous 4 week sheets to reflect that new r...
Hi Sunny, you did some work for me previously and I need some help on a wages sheet I'm currently developing. It's based on the previous formula's you...
Thanks Sunny! Exactly what I was after. Is it possible to just calculate this for the last six months (on an ongoing basis) based on the leave date...
Hi Sunny, less complicated that that. I have created a new tab in the attached (sheet 1) to make it clearer. If there is a leave date, sum all thes...
Hi Sunny, don't worry about calculating the contracted hours, this will be input in the data tab when the employee starts I don't think it needs a ...