Groups
    EXPIRED

    Excel spreadsheet help

    Banned
    Hi

    Can't work this out, and I know I should be able to do so.

    I have customers that pay me once a month, for 3 months.

    All I want is to be able to enter the first payment (example - 17th December 2014), then the next 2 cells will automatically fill with 17th Jan 2015, and 17th Feb 2015.

    I'm know I'm just being thick, someone please put me out of my misery please. It's been an awful long day.

    3 Comments

    Original Poster Banned

    Gonna answer my own question here, as it was more complex than I realised.


    Type "=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))" without quotes in a blank cell, replacing "A1" with the reference to the cell containing the date. In this example, the date in cell "A1" will increment by one month.

    in 1st cell e.g. A1, enter the date you want i.e. 17th Dec 2014
    in following cell, enter the following formula "=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))"

    In place of just placing 1 in the bolded section above, you can reference to another cell to add X number of months to customise it further.

    In first cell, type the first date, in the next cell type the second date. Then highlight both cells, take the cursor to the bottom right corner and replicate across.
    Post a comment
    Avatar
    @
      Text
      Top Discussions
      1. Important info for Ryanair customers1929
      2. Just heard this...2 ★★★★★★★★★★★★★★ congrats to all on 392k ★★★★★★★★★★★★★★7767284
      3. I want to talk about the WEATHER no politics no religion19047118
      4. The obvious next step become Ken then become Barbie1527

      See more discussions