I have a field on a form that I want to default to the next upcoming pay date. Pay dates are on the 5th and the 20th. So for example, if data is being entered into the form on the 1st, the pay date will be the 5th. If data is being entered on the 6th, the pay date will be the 20th. If data is being entered on the 21st the pay date will be on the 5th of the next month. And, (although this will only be once a year) if data is being entered on the 29th of December (for example) the pay date will be on the 5th of the next month, and the next year.
I have been tinkering around with a formula to input into the default value but I haven't had much luck - any ideas on how to build this formula (and, if not the default value, where it should be input)?
Thanks