Help with formula

miaha

Hello I am working on this new formula where are trying to calculate the verification due date. The original way we were getting the value was when the date format was in a MM/YYYY but now the dates will come in a MM/DD/YYYY format when having this format the output of the formula we created for the Verification Due Date is giving me Invalid Value do you know how I can incorporate the date to calculate my Due date?

I also tried to create a new column with the formula (=IFERROR(MONTH([Verification Date]@row) + "/" + YEAR([Verification Date]@row), "")

that would give the MM/YYYY format but when adding it to the formula it keeps on giving me Invalid Value Column




Verification Due Date Column Formula:

=IFERROR(DATE(VALUE(RIGHT([Verification Date]@row, 4)) + 1, VALUE(LEFT([Verification Date]@row, FIND("/", [Verification Date]@row) - 1)) + 1, 1), DATE(VALUE(RIGHT([Verification Date]@row, 4)) + 2, 1, 1)) - 1

Kelly Moore

Hey @miaha

I'm happy to help.

=IFERROR(DATE(VALUE(RIGHT([Verification Date]@row, 2)) + 2000 + 1, VALUE(LEFT([Verification Date]@row, FIND("/", [Verification Date]@row) - 1)) + 1, 1), DATE(VALUE(RIGHT([Verification Date]@row, 2)) + 2000 + 2, 1, 1)) - 1

Will this work for you?

Kelly

Michelle Choate 2

@miaha does this work for you? This is exactly what I would have recommended as a formula as well.