Formula to auto calculate due date

Vivien Chong

I want to auto calculate the due date for monthly stock inventory.

For February it will be 28 of the month, for the rest of the month to be 30th.

Would appreciate your assistance.

Thanks.

Mark Cronk

Hi @Vivien Chong ,

Try:

=IF(month@row=11, date(year@row,11,28), date(year@row, month@row, 30)

Work for you?

Mark

Mark Cronk

Hi @Vivien Chong ,

Try:

=IF(month@row=11, date(year@row,11,28), date(year@row, month@row, 30)

Work for you?

Mark

Vivien Chong

Thanks @Mark Cronk , I am able to get what I want with the formula you shared.

Mark Cronk

Excellent. Happy to help. Thank you for using the Community.

Be Well,

Mark