I am trying to have a date field with a date and then another date field with the date 30 days after the first date? I can't figure it out - Any ideas would be greatly received.

Date + 30

bascially I am trying to set an invoice due date which is 30 days from the date of invoice.

(Invoice date) + 30 doesn't work for obvious reasons

I have tried a few different formulas including...

& Date(Month(Invoice date) + 1;Day(Invoice date);Year(invoice date))

I can't figure it out - can anybody shed shoe light?

Thanks in advance

bascially I am trying to set an invoice due date which is 30 days from the date of invoice.

(Invoice date) + 30 doesn't work for obvious reasons

I have tried a few different formulas including...

& Date(Month(Invoice date) + 1;Day(Invoice date);Year(invoice date))

I can't figure it out - can anybody shed shoe light?

Thanks in advance

bascially I am trying to set an invoice due date which is 30 days from the date of invoice.

(Invoice date) + 30 doesn't work for obvious reasons

I have tried a few different formulas including...

& Date(Month(Invoice date) + 1;Day(Invoice date);Year(invoice date))

I can't figure it out - can anybody shed shoe light?

Thanks in advance

I'm sorry, why doesn't invoice date + 30 work? we have been using just that formula for years.

good luck!

:-)

I'm sorry, why doesn't invoice date + 30 work? we have been using just that formula for years.

good luck!

:-)

I'm sorry, why doesn't invoice date + 30 work? we have been using just that formula for years.

good luck!

:-)

it does - sorry!! had invoice date set to number rather than date. (invoice date) + 30 was the first thing I tried and when I corrected that it didn't occur to me to try again...thanks so much for replying.

it does - sorry!! had invoice date set to number rather than date. (invoice date) + 30 was the first thing I tried and when I corrected that it didn't occur to me to try again...thanks so much for replying.

it does - sorry!! had invoice date set to number rather than date. (invoice date) + 30 was the first thing I tried and when I corrected that it didn't occur to me to try again...thanks so much for replying.

any idea how to get it to ignore weekends?

any idea how to get it to ignore weekends?

any idea how to get it to ignore weekends?

invoice date + 30 + 2 * (DayOfWeek(invoice date) = 5) + (DayOfWeek(invoice date) = 6)

This will give any invoices from Thursday or Friday the same due date of the following Monday after invoice date + 30.

invoice date + 30 + 2 * (DayOfWeek(invoice date) = 5) + (DayOfWeek(invoice date) = 6)

This will give any invoices from Thursday or Friday the same due date of the following Monday after invoice date + 30.

invoice date + 30 + 2 * (DayOfWeek(invoice date) = 5) + (DayOfWeek(invoice date) = 6)

This will give any invoices from Thursday or Friday the same due date of the following Monday after invoice date + 30.