Excel Date formula
Manage your personal finances in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Excel Date formula

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Trying to create spreadsheet with 12 columns for each month of the year. I want to be able to type in an initial due date for example "01/02/02" and have the remaining formulas fill in as the next month, same day, so first column would be 01/02/02 second would be 02/02/02 3rd column would be 03/02/02, fourth is 04/02/02, etc. Then if I go back and change the initial date all the future dates will change to reflect remaining pmnt months.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Christchurch New Zealand
    Posts
    1,030
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    put the date in the cell you want to start in eg b1
    then put in b2 =b1+1 and fill across



    [ This Message was edited by: brettvba on 2002-04-18 21:16 ]

  3. #3
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-18 21:07, nephi wrote:
    Trying to create spreadsheet with 12 columns for each month of the year. I want to be able to type in an initial due date for example "01/02/02" and have the remaining formulas fill in as the next month, same day, so first column would be 01/02/02 second would be 02/02/02 3rd column would be 03/02/02, fourth is 04/02/02, etc. Then if I go back and change the initial date all the future dates will change to reflect remaining pmnt months.
    Key-in 01/02/02 in cell A2
    then key-in =EDATE(A2,1) in cell B2
    and then drag the value in cell B2 to C2, D2, E2, ....

    and you will get 01/02/02, 02/02/02, 03/02/02, ... in consecutive cells these will be all 1 month apart successively from the dat in cell A2

    HTH

    Please post back if it works for you ... otherwise explain a little further and then let us take it from there!

    _________________
    Yogi Anand
    Edit: Deleted reference to inactive web site from signature line

    [ This Message was edited by: Yogi Anand on 2003-01-19 18:33 ]

  4. #4
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-18 21:15, brettvba wrote:
    put the date in the cell you want to start in eg b1
    then put in b2 =b1+1 and fill across



    [ This Message was edited by: brettvba on 2002-04-18 21:16 ]
    Hi brettvba:
    Adding 1 to the initial value of 01/02/02 will add only one day to the original date, and then if you drag it to the right it will 1 day successively in each cell. The EDATE function facilitates changing month from the initial date entry.

    Regards!

    Yogi Anand

  5. #5
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks you guys, havent figured it out yet.
    Using =EDATE(A2,1)caused the cell to show #NAME?

  6. #6
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-18 21:35, nephi wrote:
    Thanks you guys, havent figured it out yet.
    Using =EDATE(A2,1)caused the cell to show #NAME?
    Hi nephi:
    To reiterate the procedure,

    1) enter the first date in cell A2 as 01/02/02 (you may want to format it as DATE 03/04/97 (in Excel 97)

    2) in cell B2 enter the following formula

    =EDATE(A2,1)

    3) then fill across cells C2, D2, ....

    HTH

    Regards!

    Yogi Anand


  7. #7
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thanks so much, using the EDATE function under Insert/function/Date&time, worked perfectly. You're awesome you two
    Nephi

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
  •  

 

 
DMCA.com