Adding 1 month as expiration date referring cell of registration

vincent mercado

Can someone help me in my problem, I would like to do a formula about adding 1 month as expiration date but it's always INCORRECT ARGUMENT..

=DATE(YEAR([DATE OF REGISTRATION]@row, MONTH([DATE OF REGISTRATION]@row + 1, DAY([DATE OF REGISTRATION]@row))))

vincent mercado

Can someone help me in my problem, I would like to do a formula about adding 1 month as expiration date but it's always INCORRECT ARGUMENT..

=DATE(YEAR([DATE OF REGISTRATION]@row, MONTH([DATE OF REGISTRATION]@row + 1, DAY([DATE OF REGISTRATION]@row))))

Marcelle Conradie

Hi,

Try having a look at this thread, Paul Newcome advised someone on similar matter, not sure how your sheet is set up, but you might need to have an additional column like in this example that contains the month and then add it perhaps?

Adding a number of months to a date using formulas — Smartsheet Community