Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel Date with Step function.

  • 26-02-2008 8:59pm
    #1
    bigtimecharlie
    Registered Users, Registered Users 2 Posts: 2,082 ✭✭✭


    I want to create a simple list of each Friday with corresponding date. So I set a known Friday date and then use the autofil option ( select and drag bottom right corner of required date) to select a number of cells to fill. I get many options (weekday's, months, years etc).

    But I seem to recall that previously ( a few years back) I got a "series" option where I could set a "step" value = 7 which would give me each successive Friday.

    Can anyone shed any light or alternative solutions.

    I'm using Office 2007 on windows Vista Home Basic on Dell Inspiron 6400.


Comments

  • #2
    rockal
    Registered Users, Registered Users 2 Posts: 757 ✭✭✭rockal


    bigtimecharlie wrote: »
    But I seem to recall that previously ( a few years back) I got a "series" option where I could set a "step" value = 7 which would give me each successive Friday.QUOTE]

    Option is still there - on the Home tab, in the Editing group, click Fill, and then click Series.


  • #3
    bigtimecharlie
    Registered Users, Registered Users 2 Posts: 2,082 ✭✭✭bigtimecharlie


    Yipee, thanks for the info.


Advertisement