Deleting certain days in a long string

J

Jim

Hi,
I have a long string of dates from 1900 to 1952 listed in
one colomn going down, e.g.,
01/01/1900
01/02/1900
01/03/1900
01/04/1900
01/06/1900

Say that 01/04/1900 is a SATURDAY. I want to delete every
Saturday. I've looked and looked and can't find anything
that says how to create a formula for this.

Any help is greatly appreciated.

Thanks much!
Jim G.
Elmhurst, IL
 
M

Mike

Please note that not only Excel but also Lotus display the wrong day of the week for any day before 03/01/1900.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
Sum amount of days in another coloumn 8
Complete Tax Years 1
Transferring CERTAIN Data from one worksheet to another 1
Pass date from one form to another form in MS Access 1
Highlight rows if column A matches but B is different 0
Find then highlight in yellow 6
Sharing data from one worksheet to another 0

Top