Hello, I am trying to make a budget sheet that can display all the bills based on a selected pay period.
I currently have 3 tabs.
My 1st tab only displays: monthly bills, due dates, if its auto or not, and if is is auto where it comes out from
, as well as the name of the bill such as Mortgage, or FuboTV.
Tab 2 displays: my respective pay periods for my job, the pay date, and the amount I will receive whether estimated or actual(which I type in).
Tab 3 is supposed to be able to select the pay period from a drop down menu, i.e. PP 2, 6, 21, up to 26, then show me the pay period, the date i get paid, the amount i get paid or got paid if i look into the past, and also display all the bills for those 2 weeks
For example:
On tab 3:
If i select Pay Period 21 from my drop down, which corresponds to the pay date: Oct 20th, 2020. I want the bills for the next 14 days to be displayed based on my main budget sheet page.
So, Oct 20th - Nov 2nd Bills should be displayed below the drop down
So if i have bills on Oct 23rd, Oct 26th, and Nov 2nd, I need all 3 of those bills to display. HOW DO I DO THIS?
This was just an example, attached is my actual sheet, and the 3rd tab is almost done, i just need to somehow create a filter, or match or vlookup that can somehow return and display a spilled list of my bills for those 2 weeks.
Bookmarks