Forums

We want to share an important update with our Betfair Community users.

Over the coming months, the Betfair Community platform will be winding down. The final active day for the platform will be December 21st. From December 22nd, users will no longer be able to access the platform.

Your discussions, insights, engagement, and, most importantly, feedback have helped shape the platform and guided innovation. Your feedback continues to be important to us, and we will continue to listen via our dedicated feedback channels, as well as through product testing and innovations.

To share your feedback and experience, visit: https://support.betfair.com/app/home

Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
Roger The Butler
12 Jan 10 15:48
Joined:
Date Joined: 20 Aug 02
| Topic/replies: 3,511 | Blogger: Roger The Butler's blog
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?
Pause • Switch to Standard View Excel formula question
Show More
Loading...
Report Andy Murray • January 12, 2010 3:52 PM GMT
=TEXT(B1,"dddd")


obviously replace B1 with the cell reference with the date in
Report Andy Murray • January 12, 2010 3:52 PM GMT
i might have misunderstood the question tho :)
Report Iwish Torrent • January 12, 2010 3:57 PM GMT
:) TRY Format cells- Number- Custom ddd/dd/mm/yyyy
Report Roger The Butler • January 12, 2010 3:59 PM GMT
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.
Report Andy Murray • January 12, 2010 4:26 PM GMT
my doors always open
Post Your Reply
<CTRL+Enter> to submit
Please login to post a reply.

Wonder

Instance ID: 13539
www.betfair.com