Calculated Date on a Report (Invoice)

[molsen]

I have an invoice system, where the payment due date is the last working day of the month following the invoice.

For example, if I produce an invoice on 5th June, the payment will be due on the last day of July. Any ideas what I can put in a text box to automatically calculate that date, based on the Order date?

This is the order date formula:

=[Forms]![frmInvoiceMain]![txtOrderDate]

Many thanks

 

[Mihail]

ActualDate + 2 month - (Days+1)s.
Using your example:

5.06.2013 + 2months = 5.08.2013 - (5+1)days = LastDay from July.
If LastDay = Sunday then LastDay = LastDay-2
If LastDay = Saturday then LastDay = LastDay-1

Here is another approach (maybe better than my one)

 

[Mihail]

And THIS article seems to be exactly what you are looking for.