Hi Jon Keym
If the date in A1 is a proper date & not text. Then the following formula in B1 should suit your requirement.
=YEAR(A1)
Quote:
Originally Posted by Jon Keym
Hi,
I was wondering if anyone could please help me.
I'm trying to set up a formular that says if A1 (which is a date) is between 01/01/2012-31/12/12 then B1 will say "2012".
If A1 is between 01/01/2013-31/12/2013 then B1 will say "2013" and so on.
Can anyone suggest the best way of doing this?
Thanks,
Jon.
|