# Date Calculation

This topic is 6584 days old. Please don't post here. Open a new topic instead.

## Recommended Posts

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

##### Share on other sites

• 2 weeks later...

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?

##### Share on other sites

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?

##### Share on other sites

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?

##### Share on other sites

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

good luck!

:-)

##### Share on other sites

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

good luck!

:-)

##### Share on other sites

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

good luck!

:-)

##### Share on other sites

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.

##### Share on other sites

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.

##### Share on other sites

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.

##### Share on other sites

any idea how to get it to ignore weekends?

##### Share on other sites

any idea how to get it to ignore weekends?

##### Share on other sites

any idea how to get it to ignore weekends?

##### Share on other sites

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.

##### Share on other sites

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.

##### Share on other sites

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.

##### Share on other sites

This topic is 6584 days old. Please don't post here. Open a new topic instead.

## Create an account

Register a new account