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 all! We have been experiencing an issue on site where threads have been missing the latest postings. The platform host Vanilla are working on this issue. A workaround that has been used by some is to navigate back from 1 to 10+ pages to re-sync the thread and this will then show the latest posts. Thanks, Mike.

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.

bigtimecharlie · 2008-02-26 20:59:30

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…

26-02-2008 9:59pm

#1

bigtimecharlie

Registered Users, Registered Users 2 Posts: 2,080 ✭✭✭

Join Date: November 2003

Posts: 1944

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.

0

Comments

#2 27-02-2008 9:57am

rockal

Registered Users, Registered Users 2 Posts: 757 ✭✭✭

Join Date: March 2006

Posts: 751

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.

0
#3 04-03-2008 11:32am

bigtimecharlie

Registered Users, Registered Users 2 Posts: 2,080 ✭✭✭

Join Date: November 2003

Posts: 1944

Yipee, thanks for the info.

0