Related Posts
Can confirm guys
Source: r/iOSProgramming
Hi Fishes,
Can you please give suggestion... I joined a company as a java developer... 3 yeo but when went into project I saw they r using HCL Commerce(they have ecommerce website)... Is this tech is good for java professional ? It's totally new for me. It's not like traditional java development project.
Infosys Tata Consultancy IBM HCL Technologies Amazon Capgemini Accenture Cognizant
YYY, aren’t you on my level?
How can someone rejoin tcs
Advice on Chief of Staff interviews?
Additional Posts in The Work-Life Bowl
Anyone knows what happened to the flu?
When was the last time you wore dress shoes?
I am so making this my new WFH set up!
Is there a videogames bowl?
New to Fishbowl?
unlock all discussions on Fishbowl.
Or if it is already formatted as a date- change the format setting to the date format you expect!
Format Cell-> Date-> pick format you need.
Pro
Date is stored as text then. You can use text to columns feature to get excel to read in the cells as dates
Chief
=RIGHT(LEFT(A1,5),2)+”/“+LEFT(A1,2)+”/“+RIGHT(A1,4)
Up, up, down, down, left, right, left, right, B, A, Start.
Pro
Another potentially easier way is to use the text formula
=Text([target cell", "MM/DD/YY")
This assumes the cell is actually stored as a date and will take care of all of the logic. It stores the result as text however instead of excels date code system
YY/MM/DD/YY is the true preferred date convention
👁👄👁❓
Enthusiast
Example #72 of Posts you never see in the Advertising or Creative bowls.
Pro
Oh okay 😊
=text(old date cell , "date format you want")
I’d just do two “text to columns” on the /, cut and insert column 2 in front of the first, and concatenate instead of complicated formulas.
Ya and the complicated formula will take 5 times longer too (atleast, assuming you don’t typo). I can do the above in 10 seconds.
Thanks guys!!
Rising Star
You should have it as YYYY/MM/DD
Y’all use masks at indoor rallies?
Amazing how many bad answers there are in the responses for excel from a bunch of consultants
Pro
Really, bad answers?
Y’all need alteryx