How do you create a cell to display own day, month and year?

Secant

New member
Joined
May 14, 2014
Messages
31
Reaction score
0
Points
0
Here's the problem......I want to enter Dec-1976 in cell K3, then in cell M3, I want to enter any number from 1 to 31 to represent a date....Finally, I want cell P3 to display the day number, month and year as a combination of K3 and M3 and be recognised as a legitimate day, month and year.....I would like the final display to read as follows as an example.... 23-Dec-1976. As I notice, when I enter Dec-1976 in cell K3, it displays in the formula bar a date of its own. I look forward to help. Thanks..
I am aware I could enter the day, month and year straight into a cell, but this is not what I want to do.
 
Last edited:

Rizky

New member
Joined
Apr 28, 2014
Messages
44
Reaction score
0
Points
0
=DATE(YEAR(K3),MONTH(K3),DAY(M3))

in condition, data on K3 must formatted as date not text or custom date "MMM-YYY"

Hope it works
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
You could also use

=K3+M3-1

because K£ will assume 1st of that month
 

Secant

New member
Joined
May 14, 2014
Messages
31
Reaction score
0
Points
0
Thank you both for the replies....great......both formulas work. I had to custom format the cell P3 to dd-mmm-yyyy.
Thank you.
 
Top