egafd.com • Help with Excel Spreadsheets - Page 2

Page 2 of 2

Re: Help with Excel Spreadsheets

Posted: Fri Dec 07, 2007 9:59 pm

by randyandy

Thanks Trumpton

I haven't but will give it a go now

Re: Help with Excel Spreadsheets

Posted: Sat Dec 08, 2007 10:58 am

by Trumpton

spider wrote:

> Apparently dates is excel are just number of days counting from
> 01 Jan 1901.

I thought is was from 01 Jan 1900 ?

Date change sorted

Posted: Tue Dec 11, 2007 7:15 am

by randyandy

Just to let you know.

You can change the date by using VLOOKUP and WEEKDAY functions nested together.

!drink!

Andy

Re: Date change sorted

Posted: Tue Dec 11, 2007 12:28 pm

by Trumpton

Ta Andy !thumbsup!