New Posts For Thread: Excel Help Pleasehttps://community.betfair.com/chit_chat/go/thread/view/94038/31611059/excel-help-pleaseI'm updating a spreadsheet on a daily basis where I copy the entire row onto the next row... and so forth. I can get everything to update 1 day except the day itself (Mon/Tue/Wed etc). I tried the previous cell +1 which works for the date but not theSo I just learnedhttps://community.betfair.com/chit_chat/go/thread/view/94038/31611059/excel-help-please?post_id=558699855#558699855So I just learnedTue, 21 Jan 2020 09:29:52 -0600you seem to have it sorted, but for anyone else coming across the thread you don't need to have "ddd" as an option you can just type "ddd" in the top box.https://community.betfair.com/chit_chat/go/thread/view/94038/31611059/excel-help-please?post_id=558699843#558699843you seem to have it sorted, but for anyone else coming across the thread you don't need to have "ddd" as an option you can just type "ddd" in the top box.Tue, 21 Jan 2020 09:28:36 -0600No worries guys, that link actually did help and I've got what I'm looking for. Thanks a lothttps://community.betfair.com/chit_chat/go/thread/view/94038/31611059/excel-help-please?post_id=558699801#558699801No worries guys, that link actually did help and I've got what I'm looking for. Thanks a lotTue, 21 Jan 2020 09:20:24 -0600I haven't got a ddd option in my drop down box on custom, but I may get what ram is saying if I can get the day and date in one cell, as opposed to two. I can do a date and time, but how do I do the day/date?https://community.betfair.com/chit_chat/go/thread/view/94038/31611059/excel-help-please?post_id=558699707#558699707I haven't got a ddd option in my drop down box on custom, but I may get what ram is saying if I can get the day and date in one cell, as opposed to two. I can do a date and time, but how do I do the day/date?Tue, 21 Jan 2020 09:07:36 -0600don't think it's quite clear in the link from Ramruma, but you should highlight the whole column where the days are by clicking on the column letter at the top and then format the cell as custom "ddd".https://community.betfair.com/chit_chat/go/thread/view/94038/31611059/excel-help-please?post_id=558699407#558699407don't think it's quite clear in the link from Ramruma, but you should highlight the whole column where the days are by clicking on the column letter at the top and then format the cell as custom "ddd".Tue, 21 Jan 2020 08:00:30 -0600The key observation is that the day name is just another date, or rather it should be but the suspicion is you entered it as a string. It needs to be the date, formatted as dddSee eg https://www.ablebits.com/office-addins-blog/2015/03/11/change-date-https://community.betfair.com/chit_chat/go/thread/view/94038/31611059/excel-help-please?post_id=558699185#558699185The key observation is that the day name is just another date, or rather it should be but the suspicion is you entered it as a string. It needs to be the date, formatted as dddSee eg https://www.ablebits.com/office-addins-blog/2015/03/11/change-date-Tue, 21 Jan 2020 07:25:12 -0600Could be Happy Days if you solve thishttps://community.betfair.com/chit_chat/go/thread/view/94038/31611059/excel-help-please?post_id=558698977#558698977Could be Happy Days if you solve thisTue, 21 Jan 2020 06:32:00 -0600I'm updating a spreadsheet on a daily basis where I copy the entire row onto the next row... and so forth. I can get everything to update 1 day except the day itself (Mon/Tue/Wed etc). I tried the previous cell +1 which works for the date but not thehttps://community.betfair.com/chit_chat/go/thread/view/94038/31611059/excel-help-please?post_id=558698915#558698915I'm updating a spreadsheet on a daily basis where I copy the entire row onto the next row... and so forth. I can get everything to update 1 day except the day itself (Mon/Tue/Wed etc). I tried the previous cell +1 which works for the date but not theTue, 21 Jan 2020 06:12:32 -0600