New Posts For Thread: Excel formula questionhttps://community.betfair.com/chit_chat/go/thread/view/94038/23444498/excel-formula-questionI 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?my doors always openhttps://community.betfair.com/chit_chat/go/thread/view/94038/23444498/excel-formula-question?post_id=418604398#418604398my doors always openTue, 12 Jan 2010 10:26:07 -0600Andy 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.https://community.betfair.com/chit_chat/go/thread/view/94038/23444498/excel-formula-question?post_id=418604366#418604366Andy 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.Tue, 12 Jan 2010 09:59:54 -0600:) TRY Format cells- Number- Custom ddd/dd/mm/yyyyhttps://community.betfair.com/chit_chat/go/thread/view/94038/23444498/excel-formula-question?post_id=418604358#418604358:) TRY Format cells- Number- Custom ddd/dd/mm/yyyyTue, 12 Jan 2010 09:57:03 -0600i might have misunderstood the question tho :)https://community.betfair.com/chit_chat/go/thread/view/94038/23444498/excel-formula-question?post_id=418604354#418604354i might have misunderstood the question tho :)Tue, 12 Jan 2010 09:52:34 -0600=TEXT(B1,"dddd")obviously replace B1 with the cell reference with the date inhttps://community.betfair.com/chit_chat/go/thread/view/94038/23444498/excel-formula-question?post_id=418604350#418604350=TEXT(B1,"dddd")obviously replace B1 with the cell reference with the date inTue, 12 Jan 2010 09:52:04 -0600I 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?https://community.betfair.com/chit_chat/go/thread/view/94038/23444498/excel-formula-question?post_id=418604346#418604346I 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?Tue, 12 Jan 2010 09:48:32 -0600