Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
12 Jan 10
15:48
Joined:
Date Joined:
20 Aug 02
I have a spreadsheet full of dates, ie. 01/01/2009 etc. and wish to assign the day of the week to each row.
Is there a formula that I can do this with or do I have to go through each individual row manually adding a day?
Is there a formula that I can do this with or do I have to go through each individual row manually adding a day?
Show More
=TEXT(B1,"dddd")
obviously replace B1 with the cell reference with the date in
obviously replace B1 with the cell reference with the date in
:) TRY Format cells- Number- Custom ddd/dd/mm/yyyy
Andy Murray I'm not a gayer but if I were I'd think about giving you a damn good bumming. Cheers, just saved me a lot of farting around.
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539