Select column based on date

**miss_gee_gee** · 02-21-2014, 05:11 PM

I have monthly data listed in columns. I want to select the data in the column with a header that matches the current month.
Any suggestions?

Jan 2014 Feb 2014 Mar 2014 Apr 2014 May 2014 Jun 2014 Jul 2014 Aug 2014 Sep 2014 Oct 2014 Nov 2014 Dec 2014
99 77 44 25 95 16 12 88 88 56 56 12

I know to get the current month using =month(today()) but not sure how to use that to select the value in the column with that header.

**vlady** · 02-21-2014, 09:46 PM

something like this maybe
A1 to C1 -header dates

=SUMPRODUCT((MONTH(A1:C1)=MONTH(TODAY()))*A2:C2)

Select column based on date

LinkBack

Thread Tools

Rate This Thread

Display

Select column based on date

Re: Select column based on date

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Auto fill a column based on date and color a column if past that date

[SOLVED] select a value in row based on column value

Select a Date between Two Date Rows, then the Column State and return Table Matrix Values

Select the oldest date of based on "P" in another column

Select certain columns based on date

Bookmarks

Bookmarks

Posting Permissions