INVALID COLUMN VALUE
I am trying to pull a due date based on a prior cell's value.
Example:
Column "Financials Due Date" has a value of 10
In Column "Partners Due Date" I input the following formula but receiving an error. I have the column set to Date.
=DATE(YEAR(TODAY()), MONTH(TODAY()), [Financials Due Date]@row)
Answers

For that to work, you'll want to make sure that your column [Financials Due Date] is formatted as text with just digits for the day populated....... And it will accept invalid input. For example, if Today is in February 2023 and the [Financials Due Date]@row is greater than 28, then you'll end up with a March date in your [Partners Due Date] column.

@Todd M Keller Thank you, I did this but now it says "Invalid Data Type"

So, your [Partners Due Date] column is formatted as "Date", and [Financials Due Date] column is formatted as text?

@Todd M Keller correct, top line shows changing the FDD to text, the ones below are just numbers... PDD are the errors I'm seeing

That is a puzzler for sure, I actually tried your setup in a sample sheet. With the column properties set the way I mentioned above, it appears to work.
Help Article Resources
Categories
Check out the Formula Handbook template!