View Single Post
 
Old 07-20-2018, 12:21 PM
matteu1 matteu1 is offline Windows 10 Office 2016
Novice
 
Join Date: Jul 2018
Location: Virginia
Posts: 2
matteu1 is on a distinguished road
Default Date Formula Issue

Hello,

I'm a bit of a mail merge newbie, and I tried to answer my own question by reading the sticky material.

I have a table and one of the columns is filled with dates. I've bookmarked the cell's contents and now I'm trying to perform a function on that bookmark outside of the table. I'm trying to find the max date and have the following:

{=MAX(DateTest)\@MM\DD\YY}

and the result is:

0.03125

When I test on a numeric column all works great. I know there must be a string issue but I can't figure out where I'm going wrong.
Reply With Quote