Microsoft Excel 2003 (full product)

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

You will obtain better help in the proper forum: http://www.computing.net/forum/offi...

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

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.

Ask Your Question

Weekly Poll

Do you think Amazon will be able to keep delivering despite the Coronavirus?

Discuss in The Lounge

Poll History