Subtract 1 month from the date expire for a task
ClanMcDe
ββ
I have a column that calculates a due date that uses this simple formula:
=DATE(YEAR([Date Expired]@row), MONTH([Date Expired]@row) - 1, DAY([Date Expired]@row))
It works great but for some reason returns #INVALID VALUE when the date expired is any day in January. any other month seems to be fine I'm guessing because the month prior is in a prior year. what argument will fix this?
Best Answer
-
@Paul Newcome as ussual, your insights are invaluable. Thank you for the assist!
Answers
-
Try this:
=IFERROR(DATE(YEAR([Date Expired]@row), MONTH([Date Expired]@row) - 1, DAY([Date Expired]@row)), DATE(YEAR([Date Expired]@row) - 1, 12, DAY([Date Expired]@row)))
-
@Paul Newcome as ussual, your insights are invaluable. Thank you for the assist!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!