Automate EOM Entry

Dennis Wierzbicki

Is there a way in Smartsheet to automatically look at a month, and return the end of that month (as a number)?

Thanks,

Dennis

Paul Newcome

You just want the day number of the last day of the month? If so, try something like this...

=DAY(DATE(YEAR([Date Column]@row) + IF(MONTH([Date Column]@row) = 12, 1), IF(MONTH([Date Column]@row) = 12, 1, MONTH([Date Column]@row) + 1), 1) - 1)