Due date formula

[hayekj]

Hello, which formula could I use to find the due date of a maintenance contract based on the maintenance frequency (e.g. every 1 month), start date of the contract and today's date?

Example: A security barrier contract: the contract is valid from 10/01/2018 till 10/12/2018. The frequency of the maintenance is 1 month. The due date of the next maintenance should be 10/12/2018.

Thanks a lot! J

 

[steve the fish]

If you already have a date, eg 10/11/2018, you could use:

=EDATE(A1,1)

If you want to calculate it from today:

=EOMONTH(TODAY(),-(DAY(TODAY())<10))+10

 

[hayekj]

If you already have a date, eg 10/11/2018, you could use:

=EDATE(A1,1)

If you want to calculate it from today:

=EOMONTH(TODAY(),-(DAY(TODAY())<10))+10

Thanks, but what if I do not have a specific date?

 

[steve the fish]

Thats what the 2nd formula takes care of...

 

[hayekj]

but where is the start date in this formula? You could find in this link (orange arrows) the formulas that I am looking for...Thanks! http://tinypic.com/view.php?pic=bj77sk&s=9#.XAZTUcmpV3g

 

[hayekj]

how can I also get the due date based on a start date, frequency and today's date? Thanks, Joseph

 

[gaz_chops]

Maybe start again, explaining exactly what you want, provide some sample data with the results you expect.

 

[hayekj]

Okay. Sorry if that was not clear.

I am looking to have the due date of a maintenance contract. Let us say that the start date of the contract is 01/01/2018 and the maintenance should take place monthly (every month). What I am looking for is when the next maintenance is due to take place but I want it to be based on today's date (for this example it should be 01/01/2019 since the maintenance for the month of December already took place on 01/12/2018). you can find the example below.

Contract type start date of the contract end date of the contract maintenance frequency (months) today next due date of the maintenance

Apple SAL 01/01/2018 31/12/2019 1 04/12/2018 (the formula that I am looking for - it should show 01/01/2019)


Many thanks for your help!
Joseph

 

[Phuoc]

Try this:

=EDATE(A1,DATEDIF(A1,TODAY()-1,"m")+1)

 

[hayekj]

it works thanks!! One more thing, how can I apply this formula for a bimonthly maintenance (2 times a month) ?

Thanks a lot, Joseph