1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel Dates

Discussion in 'Business Applications' started by Elizabeth999, Nov 9, 2004.

Thread Status:
Not open for further replies.
Advertisement
  1. Elizabeth999

    Elizabeth999 Thread Starter

    Joined:
    Nov 9, 2004
    Messages:
    6
    I have been using this formula to let clients know when their bills are due:
    =DATE(YEAR(A1),MONTH(A1),DAY(A1)+90)
    this ends up looking something like this: 1/1/04
    however, I have had a request from them to have it look more like this: 1-Jan-2005.
    Any help would be greatly appreciated. Thank you.
     
  2. XL Guru

    XL Guru

    Joined:
    Aug 30, 2003
    Messages:
    2,702
    Hi, welcome to the board.

    You need to use a custom format.

    There is a shortcut specifically for this format (how lucky are you?).

    Select the cell, then press the "#" key while holding down CTRL.

    Rgds,
    Andy
     
  3. Elizabeth999

    Elizabeth999 Thread Starter

    Joined:
    Nov 9, 2004
    Messages:
    6
    Many thanks, I have job security for one more day!!!
     
  4. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,452
    Hi,

    Andy, in my xl 2002 that is a shortcut for Italics. Do you mean Ctrl + Shift + 3? That is what works for me. Sorry, just clarifying. :)
     
  5. XL Guru

    XL Guru

    Joined:
    Aug 30, 2003
    Messages:
    2,702
    Hi ff. XL2K Help actually says CTRL+Shift+#. That serialised it for me, so I just tried the other at random. Go figure.

    CTRL+3 (unshifted) gives me italics. Regional Setting, mebbe. :confused:
     
  6. Couriant

    Couriant Trusted Advisor

    Joined:
    Mar 26, 2002
    Messages:
    32,603
    First Name:
    James
    what is the A1 mean? I'm trying to understand the formula and how the workbook is set up.

    BTW the type in the FORMAT > CELLS > NUMBER section, it would be d-mmm-yy
     
  7. XL Guru

    XL Guru

    Joined:
    Aug 30, 2003
    Messages:
    2,702
    A1 is the cell containing the date to which 90 days is to be added.
     
  8. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,452
    A1 is referring to a specific cell address. This is a combination of the Column and the Row. The columns are going left to right, whereas the rows are going up and down. There are 256 columns in an excel spreadsheet and 65536 rows. Those are your limitation boundaries. The rows and column headers can be found at the top and left of the spreadsheet, as depicted in the below picture.

    The rows are circled in red on the left, the columns are circled in red on the top. As you can see, there are two cells which have dark borders around them, one green and the other black. The black one is the current cell selected, and it's address will show up in the Name box, direclty to the left of the formula bar. Can you see it on the left there? The green colored border (I colored it) is cell A1. It is the column of A, and the row of 1. So one cell to the right would be cell B1, then C1 and so on and so forth.

    ...
     

    Attached Files:

  9. XL Guru

    XL Guru

    Joined:
    Aug 30, 2003
    Messages:
    2,702
    Yeah, but you just had to check, didn't you? :cool: ;)
     
  10. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,452
    I did! :D ROFL!
     
  11. Couriant

    Couriant Trusted Advisor

    Joined:
    Mar 26, 2002
    Messages:
    32,603
    First Name:
    James
    I figured it's the cell reference, it was just a weird formula. No need for the graphics ;)
     
  12. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/294275

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice