Click here for important information about Computing.net.

Excel Date If Argument Question

Tags:
Microsoft Excel 2003 (full product)
excel
March 24, 2010 at 15:38:00
Specs: Windows XP, 2000
I am trying to write a what if formula where I
compare dates from three different columns
and if the date is "y" date is greater then "x"
date I add 1 to the year, if "x" is greater than
"y" or "y" is absent I add 13 to the year marker
of "x" date. I have been toying with a formula
but can not get a test formula to work.

Formula:

=IF((DATE(YEAR(F2)>DATE(YEAR(G2)),DAT
E((YEAR(F2)+1,MONTH(F2),DAY(F2))


See More: Excel Date If Argument Question

Report •

#1
March 25, 2010 at 00:34:56
You will obtain better help in the proper forum:

http://www.computing.net/forum/offi...

Home Page http://ewen.uuuq.com/


Report •

#2
March 25, 2010 at 00:34:59
jbdahl1, that's sorta beyond my expertise, you'll likely get more and more knowledgeable responses in the programming forum @:
http://www.computing.net/forum/prog...
HTH.
Ed in Texas.

Report •
Start a discussion
Related Solutions
See More ↓


Ask Question