CODEWITHSUNDEEP
excel
NICK
NICK

Reputation: 15

Printing Value in Excel

Hello guys I have a question for you,

How do I print a month only lets say

Cell A1 = 02/04/1992 I want to print the month only of cell A1 so A2 = 02 How do I print the Month only ? into a cell?

Upvotes: 0

Views: 211

Answers (2)

Michał Turczyn
Michał Turczyn

Reputation: 37377

Use MONTH function, i.e.: =MONTH(A1). Refer to: MONTH function

Put these values in B column:

      A          B
1  05/1/2014     5
2  06/1/2014     6
3  07/1/2014     7
4  08/1/2014     8
5  09/1/2014     9

Then, in C1 place formula:

=CELL("address", INDEX(A1:B5, MATCH(6, B1:B5, 0), 1))

It will display address of a cell, in this case A2. You can write column or row instead of address in above formula to get column or row of a cell respectively.

Upvotes: 0

ZAhmed
ZAhmed

Reputation: 1290

Try this in A2 : 

=MONTH(A1)

It works fine

Upvotes: 2

Related Questions