Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Month in one cell. Year in another. How?

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Cambridge England
    Posts
    521
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I need to shown the current month (text), in say cell A1 and the current year in cell B1.
    If A45 = <=NOW()> then
    =YEAR(A45) in cell B1 gives me the current year OK but =MONTH(A45)entered in cell A1 just gives 4.
    I am sure the answer is simple but I dont know what it is. Help!!
    eD

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,021
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    On 2002-04-06 12:37, eddy wrote:
    I need to shown the current month (text), in say cell A1 and the current year in cell B1.
    If A45 = <=NOW()> then
    =YEAR(A45) in cell B1 gives me the current year OK but =MONTH(A45)entered in cell A1 just gives 4.
    I am sure the answer is simple but I dont know what it is. Help!!
    eD
    In A1 enter: =IF(B1,TEXT(A45,"MMM"),"")

    In B1 enter: =IF(A45<=TODAY(),YEAR(A45),"")


Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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