What is the formula to get Days like Monday, Tuesday etc., from Dates like 11-Sep-08?
Rms10
What is the formula to get Days like Monday, Tuesday etc., from Dates like 11-Sep-08?
Rms10
=text(a1, "dddd")
Entia non sunt multiplicanda sine necessitate
If you want to keep the value of the date
You can change the format of cell
Custom > "DDDD"
I need your support to add reputations if my solution works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks