strick206
Member
Registered: 12th Apr 07
Location: Wigan Drives:Integra DC5
User status: Offline
|
I have a spreadsheet i'm running some tests on to see what profit etc
On this spreadsheet the dates are in the format 8-Jul for example
Is there anyway i can do a formula so that the sheet can recognise the day of the week that date is, ie monday. And if so could anyone help
|
pow
Premium Member
Registered: 11th Sep 06
Location: Hazlemere, Buckinghamshire
User status: Offline
|
Right click on the cell, cell properties, type, there will be an option to display the day of the week under the "Date" section 
|
strick206
Member
Registered: 12th Apr 07
Location: Wigan Drives:Integra DC5
User status: Offline
|
Can't see an option to change it to the day of the week mate
Just various date formats
|
pow
Premium Member
Registered: 11th Sep 06
Location: Hazlemere, Buckinghamshire
User status: Offline
|
Shit me so it does.
Under format cells again, under the "Number" tab, choose custom and create a custom type. Using the code ddd will return a day of the week.
For example, typing in 01/02/10 into a cell then changing it to Custom ddd dd/mm/yy will return Mon 01/02/10.
Hope that helps _
|
strick206
Member
Registered: 12th Apr 07
Location: Wigan Drives:Integra DC5
User status: Offline
|
Perfect, thanks mate that's exactly what i wanted 
|
pow
Premium Member
Registered: 11th Sep 06
Location: Hazlemere, Buckinghamshire
User status: Offline
|
|
strick206
Member
Registered: 12th Apr 07
Location: Wigan Drives:Integra DC5
User status: Offline
|
Ahhh got a problem, when i run an IF formula to search for the day it throws up, i get no matches because the cell is only displaying Mon, Tue etc, it still has the actual date in
|
