MS Excel 2K13, IF/THEN formula

[jhearne]

Anybody shed some light on Excel formula "IF".
I have two columns: "Date Trained" and "Current". The end state is to have "Current" populate with True/False if the date entered in "Date Trained" is over a year old.

I was working with this: IF(A2<=TODAY()-365, TRUE, FALSE))

Thoughts?

 

[mklinge]

Looking fine to me, what is you asking?

I have cleaned it a bit here:

IF(A2<=Today()-365, true(),FALSE())

//M

 

[jhearne]

I guess it was the "Cleaning" that was needed! It works perfectly now. The error before was "#NAME"...but all is well now!

Thanks!

 

[mklinge]

I guess it was the "Cleaning" that was needed! It works perfectly now. The error before was "#NAME"...but all is well now!

Thanks!

YW

All i really did was making sure you had the right () in the right places

//M