Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-20-2018, 12:21 PM
matteu1 matteu1 is offline Date Formula Issue Windows 10 Date Formula Issue Office 2016
Novice
Date Formula Issue
 
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 Date Formula Issue Windows 10 Date Formula Issue Office 2016
Novice
Date Formula Issue
 
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 Formula Issue 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
Date Formula Issue MS Project Date Range Issue appelguy@gmail.com Project 2 10-31-2015 11:52 AM
Date Formula Issue Formula Paste Issue rabend Excel 3 06-02-2014 12:06 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:20 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft