Chit Chat
Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
I'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 the day. Anyone know the formula for this?
TIA
TIA
Show More
The 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 ddd
See eg https://www.ablebits.com/office-addins-blog/2015/03/11/change-date-format-excel/#custom-date-format
Of course, this raises the question why you have split the date into two different cells in the first place.
See eg https://www.ablebits.com/office-addins-blog/2015/03/11/change-date-format-excel/#custom-date-format
Of course, this raises the question why you have split the date into two different cells in the first place.
don'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".
I 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?
No worries guys, that link actually did help and I've got what I'm looking for. Thanks a lot 
you 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.
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539