Excel help question of the day.

Home Forum Chat Forum Excel help question of the day.

Viewing 5 posts - 1 through 5 (of 5 total)
  • Excel help question of the day.
  • Premier Icon BoardinBob
    Subscriber

    =A1+7

    (assuming A1 is where the date is so replace A1 with whatever cell your date is in)

    cheez0
    Member

    Put the first two dates in, then highlight them both and pull the fill handle across to auto populate the other cells.

    cheez0
    Member

    *or down, in this case.

    phil.w
    Member

    sweeeeeeet
    thanks guys

    🙂

    phil.w
    Member

    As I know there are a few excel masters on here…

    I have a column titled ‘week ending’ with the dates below in the format 09-Oct-11
    16-Oct-11
    etc.

    To save me typing the new date each week can I get excel to do it for me?

    In an ideal world i’d keep the format how it is but if it needs changing i.e. 09-10-11 then I might be able to live with that.

    Thanks in advance. 🙂

Viewing 5 posts - 1 through 5 (of 5 total)

The topic ‘Excel help question of the day.’ is closed to new replies.

Comments are closed, but trackbacks are open.

Skip to top