Thread: date formulas

Hi

I used to have a quite a dynamic budget spreadsheet, however it was becoming far to big and slow,
I am now slowly creating a new budget spreadsheet however entering dates is becoming a real chore, I have tried watching some of the videos via you tube but still unable to find a solution to my problem.

What it is I would like to do is (please open sample sheet INCOME) enter the date in cell C5 and the income in D5 and from a drop down list in cell E5 from weekly, fortnightly, 4 weeks, monthly or set date of the month would then auto generate the correct dates into row 5

a 3 month window would be a nice touch too so once i delete a row the table would auto gen new dates like a rolling track

Many Thanks for helping







I do hope you can understand and seek me a solution

Thanks

Any chance you could edit your post and put in punctuation to help parse out your sentences or, better yet, bullet points of what you need? Also, we don't necessarily need everything in the workbook, just a sample of the actual issues, along with a few correct outputs, would do nicely.

I do hope you can understand and seek me a solution

Nope I don't understand

in the income and outgoing cell refrence columns E would be from a drop down list,
dates in cell refrence column F would be auto generated from the date given in column C and E
same goes for the outgoing sheet
as for other spending is that I can enter an amount paid in or out on a specific date and be scenerioed onto sheet 3 for a daily allownance from balance each month,

hope this helps to get my answer