Add or Subtract Days, Months, or Years current Date and month and year

Business Central/NAV
1

how should I calculate current month to next months as per customer given For example
I have Date Field “Start Date” (01-01-2022)
I have Contract Period Filed Customer should give In this field 06 Months contract period so
That ending date automatically return should be like this (01-06-2022)

2

To find the first day of next month you could use CM+1D (where CM takes you to the last day of the current month and 1D takes you 1 day further).
To go to first day 6 months from now I would play around with +5M+CM+1D
That should get you close to what you need.
Hope it helps.
Heinrich

3

To calculate the ending date based on the start date and the contract period provided by the customer, you can use the following formula:

=EDATE([Start Date], [Contract Period])

In this formula, Start Date is the cell containing the start date (01-01-2022 in your example) and Contract Period is the number of months in the contract period (6 months in your example). The EDATE function adds the specified number of months to the start date to calculate the ending date.

In this example, the formula would be:

=EDATE(“01-01-2022”, 6)

which would return the ending date of the contract period as 01-06-2022.