DATE FORMULA

Posted by Ioanna on February 14, 2002 12:11 AM

I would like to create a formula that compares some date from past year (2001) and if the current date is >6 months returns 1

for instance: if today>6 months for (2001) then 1;0

Thank u very much

Posted by Aladin Akyurek on February 14, 2002 2:07 AM

Not sure what you're after, but try:

=(EDATE(A3,6)>TODAY())+0

Format the cell of this formula as General. If you get a #NAME? error, add Analysis Toolpak via Tools|Add-Ins.

====================

Posted by Ioanna on February 14, 2002 2:57 AM

To: Aladin Akyurek

Thank you very much. That was really very helpfull