0IN THIS SCENARIO, WE WILL HELP OF TEXT FUNCTION WE FIND OUT DATE, MONTH, YEAR
| A | B | C | D | E | F | |
| 1 | ||||||
| 2 | =TEXT(B3,"DDD") | =TEXT(B3,"MMM") | =TEXT(B3,"YYY") | |||
| 3 | 12-09-2019 | Thu | Sep | 2019 | ||
| 4 | 12 | 09 | 19 | |||
| 5 | =TEXT(B3,"dd") | =TEXT(B3,"MM") | =TEXT(B3,"YY") | |||
| 6 |
Learn Microsoft Excel Training from the Best Tutors
Affordable fees
1-1 or Group class
Flexible Timings
Verified Tutors
Search in
IN THIS SCENARIO, WE WILL HELP OF TEXT FUNCTION WE FIND OUT DATE, MONTH, YEAR
| A | B | C | D | E | F | |
| 1 | ||||||
| 2 | =TEXT(B3,"DDD") | =TEXT(B3,"MMM") | =TEXT(B3,"YYY") | |||
| 3 | 12-09-2019 | Thu | Sep | 2019 | ||
| 4 | 12 | 09 | 19 | |||
| 5 | =TEXT(B3,"dd") | =TEXT(B3,"MM") | =TEXT(B3,"YY") | |||
| 6 |
Find Microsoft Excel Training classes near you
Learn from Best Tutors on UrbanPro.
Are you a Tutor or Training Institute?
Join UrbanPro Today to find students near you35 Answers
The best tutors for Microsoft Excel Training Classes are on UrbanPro
The best Tutors for Microsoft Excel Training Classes are on UrbanPro
