Hi, im trying to create a spreadsheet to keep track of savings for multiple different things which all go into the same bank account, eg. gas, electricity, holiday fund etc. I am paid every two weeks and so each "virtual" account will be paid into every two weeks. I have decided to create multiple sheets for each items projected savings and one overall Totals sheet. What i need is a formula which will display the current balance in the account based on todays date. It would need to look at column "A" and see which fortnightly period today is part of and then select the appropriate cell in the Balance column "D" and display it in G4. Is this possible? Any help would be greatly appreciated. Thanks! Excel formula puzzle.jpg
Bookmarks