Hello fellow excel users,
I had a quick question. What does this formula mean?
=IF(ISTEXT(A2),REPLACE(MID(A2,4,3)&A2,7,3,"")+0,DATE(YEAR(A2),DAY(A2),MONTH(A2)))
I get the gist but can someone break it down for me please?
Appreciate the help!
Hello fellow excel users,
I had a quick question. What does this formula mean?
=IF(ISTEXT(A2),REPLACE(MID(A2,4,3)&A2,7,3,"")+0,DATE(YEAR(A2),DAY(A2),MONTH(A2)))
I get the gist but can someone break it down for me please?
Appreciate the help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks