Microsoft Office Forums Date Formula Issue

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 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


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


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