PIYUSH SINGH (student) (2471 Points)
20 September 2012
Ganeshbabu K
(Audit and Tax Advisory)
(48564 Points)
Replied 20 September 2012
please Solve this assignment,
u have to extract date from data,
and let me knowa how u solved it,
All the best
Thanks&Regards
Ganeshbabu
ganeshbabu.tax @ gmail.com
PIYUSH SINGH
(student)
(2471 Points)
Replied 20 September 2012
* Krishna *
(CA Student)
(6149 Points)
Replied 21 September 2012
@ Piyush-Use this formula: =MAX(IFERROR(DATEVALUE(MID(B4,ROW($1:$100),10)),""))