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.
Yes (14) | ![]() | |
No (14) | ![]() | |
I don't know (15) | ![]() |