Formula to auto calculate due date

Vivien Chong ✭✭✭✭✭✭

12/17/20 in Formulas and Functions

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.

Vivien Chong

Modern Work Management Consultant @ 57Network Consultancy Sdn Bhd

Connect with us: 57network.com

0 · Share on FacebookShare on Twitter

Sign in

Try Smartsheet

Best Answer

• 

  Mark Cronk ✭✭✭✭✭✭

  12/17/20 edited 12/17/20 Answer ✓

  Hi @Vivien Chong ,

  Try:

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

  Work for you?

  Mark

  
  

  I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  2 · Share on FacebookShare on Twitter

Answers

• 

  Mark Cronk ✭✭✭✭✭✭

  12/17/20 edited 12/17/20 Answer ✓

  Hi @Vivien Chong ,

  Try:

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

  Work for you?

  Mark

  
  

  I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  2 · Share on FacebookShare on Twitter
• 

  Vivien Chong ✭✭✭✭✭✭

  12/17/20

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

  Vivien Chong

  Modern Work Management Consultant @ 57Network Consultancy Sdn Bhd

  Connect with us: 57network.com

  0 · Share on FacebookShare on Twitter
• 

  Mark Cronk ✭✭✭✭✭✭

  12/17/20

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

  Be Well,

  Mark

  
  

  I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  0 · Share on FacebookShare on Twitter

Sign in

Try Smartsheet

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list