I am building a spreadsheet to track income and expenses. I currently have to manually input the number of paychecks remaining for the year. I get paid every other week. I have it where the date changes appropriately everytime I open the file(this is of course a simple formula).
My goal: To have the sheet automatically update everytime I open it.
For example, the attached file has 3 red cells. I would like these 3 cells to automatically update everytime I open the sheet. With these automatically updated I will be able to more effectively forecast my income and expenses.
Thanks in advance.
Adam
Bookmarks