Excel date or edate function help

		Microsoft Office Forums > Microsoft Excel > Excel
Excel date or edate function help

FAQ

Thread Tools

Display Modes

07-17-2013, 01:44 AM

JohanB26

Windows 7 64bit Excel date or edate function help

Office 2010 32bit

Novice

Join Date: Jul 2013

Posts: 1

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.

« Previous Thread | Next Thread »

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

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