Formula does not add all months

[Camel123]

Hi,

Column J shows the leasing period in months, when start date is entered (col. K), then the end date (col. L) is automatically calculated by this formula: =IF(AND(J4<>"";K4<>"");K4+DATE(0;J4;0);"")

Please see URL for screenshow below. On the red marked rows, it does not add all months (see col. J vs N), should be an additional one included. On the black marked rows, it calculates the correct number of months (col. J=N). The same formula is applied in all rows.

What is the reason and how can I solve this issue?


https://imgur.com/a/cYM3oc3

 

[steve the fish]

See if this works:

=EDATE(K4,J4)-1

 

[Camel123]

Thank you Steve it worked perfectly! :D