![]()
="IIMS:"&YEAR(C2)&"-"& TEXT(MONTH(C2),"mm")&"-"&TEXT(DAY(C2), "dd") &"-"& TEXT(MID(D2,FIND("S",D2)+1,FIND(":",D2)-FIND("S",D2)-1),"00000")
![]()
="IIMS:"&YEAR(C2)&"-"& TEXT(MONTH(C2),"mm")&"-"&TEXT(DAY(C2), "dd") &"-"& TEXT(MID(D2,FIND("S",D2)+1,FIND(":",D2)-FIND("S",D2)-1),"00000")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks