Recurring Monthly Expenses

[ruchperformive]

Hello,

Issue - Currently my issue is we have recurring expenses that appear every month on the same day of every month. Since we will be processing all payments on Friday we want expenses to recur every month but if the day falls on any weekday besides Friday, I want expenses to occur to next nearest Friday.

Sheet Link I'm attaching an excel file where I'm showing the issue and below I'm showing the desired outcome

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: recurring Revenue every month but expenses always appears to next nearest friday
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.