Results 1 to 4 of 4

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

  1. #1

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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 by Secant; 2014-05-18 at 10:32 PM.

  2. #2
    =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

  3. #3
    You could also use

    =K3+M3-1

    because KŁ will assume 1st of that month

  4. #4
    Thank you both for the replies....great......both formulas work. I had to custom format the cell P3 to dd-mmm-yyyy.
    Thank you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •