Using the If function for a date range

[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) i
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 s
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

 

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

 

[Jon Keym]

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]

Works perfectly. Thanks very much.

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