Using =MAX( to get latest date on Dashboard

AGK

HELLO! I am trying to get the very last date on a sheet to display on my dashboard. I am using the MAX function to return the date but I keep getting an error…..I have tried the below

=MAX({Target Complete}) ….this returns #INVALID COLUMN VALUE

=MAX({Target Complete}:{Target Complete}) ….this returns #UNPARSEABLE

=MAX([Target Complete]:[Target Complete]) ….this returns #UNPARSEABLE

The sheet I am trying to reference is more of a checklist than a project plan with parent/children relationships so I cannot simply reference the top parent date cell to display.

Thank you for the help!

Paul Newcome

Make sure both the reference column and column you have the formula in are set as date type columns.

Paul Newcome

Make sure both the reference column and column you have the formula in are set as date type columns.

AGK

Oh my gosh….thank you yet again Paul for identifying my silly mistake :) Oopsie!

Paul Newcome

Happy to help. 👍️