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 |