Hi
1) For the first one I think you need to work with your team. if they want to stay with 25 and paying it in 30 days is not an option for them or it does not cause any issue then maybe set the payment to 25 days. But add the 30 days in description for the future use.
2) What happens to invoices after 25th? I mean if no invoices after 25th then maybe you can try CM+10D which is end of the current months plus 10 days
3) This is the most complex one since it goes between 2 months. For example we could use formula like 30D+1M-CM+D10 which does the following but will not work
3.1) for 2/26 will add 30 days to it which is 3/28/2022 then add 1 month to it which is 4/28/2022 then bring it back to
4/1/2022 then calculate day 10th which is April 10th.
3.1) for 3/25 will add 30 days to it which is 4/25 then 1m which is 5/25 then 5/1 and then 5/10
Even if we use formula like 5D+1M-CM+D10 then will not work again. I think you can open excel file and see if by using following logics you can find the formula for it
C = Current
D = Day
W = Week
M = Month
Q = Quarter
Y = Year
CD = Current Day
CW = Current week
CM = Current month
5D = 5 days from today
4W = 4 weeks from today
D20 = The next 20th day of a month
WD3 = The next 3th day of a week
CM+5D = Current month + 5 days
