Excel formula not working in a table but works in a range

Asked Nov 17 '21 at 19:43

Active Nov 17 '21 at 19:57

Viewed 102 times

I have a very basic excel formula which works in a range but when I bring the data into a table the formula does not provide the correct results.

the formula is

=MAX([@[sub_date]]:[@[sup_date]])

when this data is in a range the formula is Max(c2:d2)

Why is this working in the range but not the table.

edited Nov 17 '21 at 19:57

Scott Craner

asked Nov 17 '21 at 19:43

Ross

1

Try: `=MAX([@[sub_date]:[sup_date]])` – Scott Craner Nov 17 '21 at 20:00
That gave me the same result – Ross Nov 17 '21 at 20:34
1

Ahhhhhhh, Your dates in the table are text that look like dates and not true dates. They need to be converted to true dates. – Scott Craner Nov 17 '21 at 20:41

0 Answers0