Hello,
I have hourly data that I am trying to convert the numerical date to the actual day. How is this done. I have tried WEEKDAY(A1:1) and cannot get it to work.
File attached
Thankyou
Hello,
I have hourly data that I am trying to convert the numerical date to the actual day. How is this done. I have tried WEEKDAY(A1:1) and cannot get it to work.
File attached
Thankyou
try this
Formula:Please Login or Register to view this content.
Last edited by zbor; 04-24-2014 at 08:28 AM.
Hi,
Assuming your values are always of an identical format:
=0+REPLACE(REPLACE(A1,5,0,"/"),8,0,"/")
Custom Format cell as dddd if desired.
Regards
or you could use
=TEXT(TEXT(A1,"0000-00-00"),"yyyy-mm-dd")
or use the formula
TEXT(A1,"0000-00-00") and format custom
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
Aha,
I get it now; you convert it using number format.
Thankyou!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks