Help

Re: Need quick help with a payment schedule formula

443 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Alaena_VanderMo
4 - Data Explorer
4 - Data Explorer

Hi Everyone! Please read and let me know what your turn around time and fee would be here…I need some help with the following:

If created date is in the last two weeks, and between the 1st and the 15th, payment is due on the 15th.

If created date is in the last two weeks and between the 16th and last day of month, payment is due on the last day of the month.

If payment is due on the 15th, payment will be issued on the 19th
If payment is due on the last day of the month, payment will be issued on the 4th.

So fields are: submitted (created at date), Due Date (formula/date), Issue Date

Submitted: 4/3/2018
Due: 4/15/2018
Issue: 4/19/2018

Submitted: 5/22/2018
Due: 5/31/2018
Issue: 6/4/2018

Submitted: 2/16/2018
Due: 2/28/2018
Issue: 3/4/2018

1 Reply 1

Answered you here:

For future reference, the #work-offered section is usually for posting paid work opportunities. If you’re just looking for help with some formulas, you can just post to #support and it will get addressed there.

…although, I’m happy to take your money for the support :stuck_out_tongue_winking_eye: