Help with Date function please:

Graeme Baker

 

20th of the month.....

 

01/01/17 returns 20/01/17 .....need 20/02/17

31/01/17 returns 20/03/17.....need 20/02/17

 

#Invalid Data Type if Invoiced date empty (Where dose IFERROR go)

 

DATE(YEAR([Invoiced Date]2), MONTH([Invoiced Date]2 + 30), 20)

Shaine Greenwood

Hi Graeme,

 

I've responded to Heath's discussion on this: https://community.smartsheet.com/discussion/20th-following-month-formula

 

The formula that you've pasted will add the number 30 to the months, which will give you an invalid.

 

As for IFERROR, you can check out the syntax for this formula in our Help Center: https://help.smartsheet.com/articles/775363-using-formulas#iferror