Formula to Match a text year against a =text(date,"yyyy") and return a 1 value

**john dalton** · 05-14-2014, 09:41 AM

Hi I have a drop down list with text years in (2014, 2015 etc)

I need a formula that looks at todays date and displays a one in a cell if the relevent year is selected in the drop down list.

Probably simple but everything I have tried has failed.

Thanks in advance

JD

**nathansav** · 05-14-2014, 09:46 AM

=if(year(today())=a1,1,"") where a1 is where your drop down list passes value to.

**john dalton** · 05-14-2014, 09:52 AM

Thanks for that Nathan, its a case of looking at something so for so long the obvious answer goes out of the window.

Cheers

JD

**nathansav** · 05-14-2014, 10:16 AM

Cant see the wood for the wood :o)

Formula to Match a text year against a =text(date,"yyyy") and return a 1 value

LinkBack

Thread Tools

Rate This Thread

Display

Formula to Match a text year against a =text(date,"yyyy") and return a 1 value

Re: Formula to Match a text year against a =text(date,"yyyy") and return a 1 value

Re: Formula to Match a text year against a =text(date,"yyyy") and return a 1 value

Re: Formula to Match a text year against a =text(date,"yyyy") and return a 1 value

Thread Information

Users Browsing this Thread

Similar Threads

need macro to filter only the date which has the format "mm/dd/yyyy" and not text date

[SOLVED] Formula TEXT returns "yyyy" instead of the real year number

[SOLVED] [COLUMN]Match Month and Year of date Only, [ROW] row that has Text "Total" on Column A

How can I tell Match to return "text content" in cell instead of where it's located?

[SOLVED] Find multiple "text" criteria and return as ""Yes" in Matrix

Bookmarks

Bookmarks

Posting Permissions