Forum Discussion
Recurring entry list of bills each month.
I have a list of monthly bills. The list is for one month. I would like to create a new list that will use the same day of the month but advance the month format by one each time it recures. A...
If I am understanding you correctly, I do not need a running list. I just need to focus on the Day date to generate each month's report then use a filter formula to weed out the ones that are past the ending date? If so, can you show me how to express that formula. I am new and I know there is a certain order to write that for it to filter correctly. Would I start with a "=DATE" formula first?
Copy your list to new location. in the date copy this formula
=DATE(YEAR(D2),MONTH(D2)+1,DAY(D2))
I am considering the data is in the cell D2 which you are refering.
Copy the above formula to rest of the list. THis will change your monthly dates
For weekly, change the formula to
=DATE(YEAR(T2),MONTH(T2),DAY(T2)+7)
this will add 7 days to the date.
Similarly for bi-weekly change the formula to
=DATE(YEAR(T2),MONTH(T2)+1,DAY(T2)+14)
Once you have done for next list, copy the whole list alongwith the formula to get the incremented value.
Hope this resolves your problem
=DATE(YEAR(D2),MONTH(D2)+1,DAY(D2))
I am considering the data is in the cell D2 which you are refering.
Copy the above formula to rest of the list. THis will change your monthly dates
For weekly, change the formula to
=DATE(YEAR(T2),MONTH(T2),DAY(T2)+7)
this will add 7 days to the date.
Similarly for bi-weekly change the formula to
=DATE(YEAR(T2),MONTH(T2)+1,DAY(T2)+14)
Once you have done for next list, copy the whole list alongwith the formula to get the incremented value.
Hope this resolves your problem