Formula Date Not Syncing With Conditional Formatting

aaronh123

Hi, I'm trying to automate my start date and due date columns. In order to do this, I'm essentially hard coding the month and day piece of the function (e.g. "01/01") and then extracting the annual piece of the function from the Task column (e.g. "2024" to "24"). The output, I believe, is similar as it would be in excel and is being recognized as a "text" format, as opposed to a date format. As a result, the Gantt chart is not picking it up nor is that value able to be used in my standing formula (as shown below).

My question, then, is there a formula or way to convert this text format into a date format so that my formulas work appropriately?

Matt Lynn ACT

@aaronh123 Yes, when you use a formula like the right() it does convert it to text and loses the date functionality. You would bury that into a date() formula to keep the date functionality.

Try this:

=DATE(VALUE(RIGHT(Task@row, 2)), 1, 1)

Matt Lynn ACT

@aaronh123 Yes, when you use a formula like the right() it does convert it to text and loses the date functionality. You would bury that into a date() formula to keep the date functionality.

Try this:

=DATE(VALUE(RIGHT(Task@row, 2)), 1, 1)

aaronh123

Thanks Matt,

That worked very well for us, thank you!