#1
|
|||
|
|||
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. |
#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.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Date Format Issue | 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 |
MS Project Date Range Issue | appelguy@gmail.com | Project | 2 | 10-31-2015 11:52 AM |
Formula Paste Issue | rabend | Excel | 3 | 06-02-2014 12:06 PM |