Excel Date If Argument Question

Microsoft Excel 2003 (full product)
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 •

Related Solutions


Ask Question