Results 1 to 4 of 4

Thread: Enter a day number, and show day/month/year from another cell
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Sep 2006
    Posts
    46
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Enter a day number, and show day/month/year from another cell

    Hi,

    Iím getting tired of entering dates into a spreadsheet. I have a master date for each month (example: 1/1/2020) and want to create a formula so as I enter 5, the cell with the formula will show 5/1/2020 - relevant to the month/year of the master cell.

    I tried the DATE formula but could only get it to work for January of current year, and similarly linking to a master cell returned a num error. I donít think thatís the right approach. Any tips please?

    Thanks

  2. #2
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    40,976
    Post Thanks / Like
    Mentioned
    90 Post(s)
    Tagged
    21 Thread(s)

    Default Re: Enter a day number, and show day/month/year from another cell

    Is this the sort of thing you mean? If not, more details & examples & layout please.

    Master date is in E1
    Enter day in column D, formula in E2 is copied down.

    Date

    DE
    1 1/01/2020
    255/01/2020
    32525/01/2020

    Spreadsheet Formulas
    CellFormula
    E2=$E$1+D2-1


    Excel tables to the web >> Excel Jeanie HTML 4
    Hope this helps, good luck.
    Peter
    Excel 365 - Windows 10
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the # key in the Reply window
    - Read: Forum Rules, Forum Use Guidelines, & FAQ

  3. #3
    New Member
    Join Date
    Sep 2006
    Posts
    46
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Enter a day number, and show day/month/year from another cell

    Oh wow, simple. This solved it, thanks.

  4. #4
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    40,976
    Post Thanks / Like
    Mentioned
    90 Post(s)
    Tagged
    21 Thread(s)

    Default Re: Enter a day number, and show day/month/year from another cell

    Quote Originally Posted by MKB View Post
    Oh wow, simple. This solved it, thanks.
    You're very welcome. Thanks for the confirmation.
    Hope this helps, good luck.
    Peter
    Excel 365 - Windows 10
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the # key in the Reply window
    - Read: Forum Rules, Forum Use Guidelines, & FAQ

Some videos you may like

User Tag List

Tags for this Thread

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
  •