Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-17-2013, 01:44 AM
JohanB26 JohanB26 is offline Excel date or edate function help Windows 7 64bit Excel date or edate function help Office 2010 32bit
Novice
Excel date or edate function help
 
Join Date: Jul 2013
Posts: 1
JohanB26 is on a distinguished road
Default Excel date or edate function help

Hi guys,



I have a date in column G9, but I want column H9 to display the exact same date, but a year later.

this is what I have tried so far and without any success, I keep getting an error from excel.

=DATE(YEAR(G9),MONTH(G9)+12,DAY(G9))

and

=EDATE(G9,12)

both times I keep getting an error.
Reply With Quote
  #2  
Old 07-17-2013, 06:01 AM
CGM3 CGM3 is offline Excel date or edate function help Windows XP Excel date or edate function help Office 2007
Advanced Beginner
 
Join Date: Oct 2009
Posts: 38
CGM3 is on a distinguished road
Default

Hmm, I have no problem (see attached).

Could the G9 cell be in text format (or displayed using the TEXT() function), or contain something like leading or trailing characters that would essentially make the value NOT a date/time?
Attached Files
File Type: xls DateTest.xls (22.0 KB, 1 views)
Reply With Quote
  #3  
Old 07-17-2013, 09:23 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Excel date or edate function help Windows 7 64bit Excel date or edate function help Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,406
Pecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to all
Default

And what type of error do you get?
__________________
Please note I am not active on this forum anymore
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
If Function Challenge involving date no1texan Excel 6 07-15-2012 12:58 PM
Change format of date when using Now function in VB code Bondai Excel Programming 2 03-02-2012 05:09 PM
Excel date or edate function help Today's Date Function freschij Excel 3 02-11-2011 10:21 AM
Automatic Date Function Corrupting Printer Output Theodulf Word 0 05-28-2010 12:33 PM
Date Function in word? aligahk06 Word 1 04-21-2010 06:33 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 06:21 AM.


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