Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
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
  #2  
Old 07-23-2018, 04:53 AM
matteu1 matteu1 is offline Windows 10 Office 2016
Novice
 
Join Date: Jul 2018
Location: Virginia
Posts: 2
matteu1 is on a distinguished road
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 07:43 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft