![]() |
#1
|
|||
|
|||
![]()
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. |
#2
|
|||
|
|||
![]()
I think my issue is actually with trying to calculate the MAX over the date range. I added MIN to the same merge document and the result is also 0.03125. I read the guides in the sticky which led me to creating a book mark for the date value in my mail merge table. Aside from that, I'm not sure what else to do, but I can be certain my calculation needs to be reevaluated.
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Jay_P | Mail Merge | 15 | 09-07-2018 01:47 PM |
Formula for looking at 1 cell with a date and then comparing it to four date ranges | LearningMom | Excel | 3 | 10-27-2017 12:44 PM |
Stacked Bar chart date issue | petermikula | Excel | 3 | 02-21-2017 05:55 PM |
![]() |
appelguy@gmail.com | Project | 2 | 10-31-2015 11:52 AM |
![]() |
rabend | Excel | 3 | 06-02-2014 12:06 PM |