If today is january then return cell B1 in C1

Question

Level 1

4 points

If today is january then return cell B1 in C1

Hi Everybody,

Having difficulties to find out the right way to do the following: I'd like to tell cell C1 that if today is January then fill C1 with B1, if it's february then B4 etc...

A Date	B	C
1	01/01/15	23	if today is january then B1, if today is february then B4, if it's march then b7 and so on
2	02/01/15
3	03/01/15
4	01/02/15	44
5	02/02/15
6	03/02/15
7	so forth...

How should I do it?

Thanks in advance

MacBook Pro with Retina display, OS X Yosemite (10.10.2)

Posted on Mar 6, 2015 12:04 PM

Reply

Answer 1

Best reply

SGIII

Level 8

35,282 points

Mar 6, 2015 12:33 PM in response to mfigari

This should do what you want:

In cell C1:

=OFFSET($B$1,(MONTH(TODAY())−1)×3,0)

This assumes the number of blank cells between values is always 2.

SG

Reply

Answer 2

mfigari Author

Level 1

4 points

Mar 6, 2015 12:54 PM in response to SGIII

No, it is not really what I am looking for...forget the table above it is confusing.

This is what I got from your help and it is actually working:

=IF(MONTH(TODAY())=3;C36;"")

Now, what if I want to extend the formula for all the months in the year and cell "C36" changes based on the month it'll be?

Reply

Answer 3

SGIII

Level 8

35,282 points

Mar 6, 2015 1:04 PM in response to mfigari

It's hard to answer without knowing how your table is set up, as you say it is different from what you have posted.

SG

Reply

Answer 4

mfigari Author

Level 1

4 points

Mar 6, 2015 1:28 PM in response to SGIII

Ok,

In the table below I have cell C36 that counts how many days I worked on January (Every month of 2015 has a separate table but in the same sheet):

In another table (in a different sheet) I have to put in cell D2 the total days I worked the actual month:

So, If today is January then D2 will be C36 (from January's table), but if today is February then D2 will be cell C36 (from February's table) and so on...

Hope is clearer 😐

Reply

Answer 5

SGIII

Level 8

35,282 points

Mar 6, 2015 1:53 PM in response to mfigari

You could try something like this:

The formula in D2 of the Summary table: =INDIRECT(MONTH(TODAY())&"::C7")

Each table would be named for the number of the month: January named '1', February '2' , etc. (Be sure not to use the same table name twice.)

You would replace the C7 in the formula with C36 (this assumes you have put the relevant number in cell C36 of each table).

SG

Reply