[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.

[Claus Busch]

Hi Jon,

Am Wed, 30 Jan 2013 12:04:20 +0000 schrieb Jon Keym:

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.

in B1 try:
=YEAR(A1)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

[Kevin@Radstock]

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)

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.

[Jon Keym]

Originally Posted by Kevin@Radstock

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)

Works perfectly. Thanks very much.

[johnhy]

Originally Posted by Jon Keym

Works perfectly. Thanks very much.

in future you can also refer to www.excelformulaslist.com which has explanation and examples for tons excel formulas