Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using the If function for a date range
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using the If function for a date range
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 |
#3
|
|||
|
|||
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:
|
#4
|
|||
|
|||
Works perfectly. Thanks very much.
|
#5
|
|||
|
|||
in future you can also refer to www.excelformulaslist.com which has explanation and examples for tons excel formulas
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF function and date range | Excel Programming | |||
IF function and date range | Excel Programming | |||
MAX figure within a date range as a function of today()'s date | Excel Worksheet Functions | |||
SUMIF within date range as a function of today()'s date | Excel Worksheet Functions | |||
How to use Date range function in Sum(if....) | Excel Discussion (Misc queries) |