date entry
=IF(LEN(A1)=0,"",DATE("20"&RIGHT(A1,2),MID(A1,7,2) ,MID(A1,FIND
("/",A1)+1,2)) )
On 28 Maj, 11:58, aditya wrote:
It works well if data is there Â*in A1 but shows value error when A1 cell is
blank.
i want the cell blank if A1 is blank.
what should i do?
"Jarek Kujawa" wrote:
format as "dd mmm yy"
=DATE("20"&RIGHT(A1,2),MID(A1,7,2),MID(A1,FIND("/",A1)+1,2))
this formula will give you "01 feb 09"
pls click YES if this helped
On 27 Maj, 14:23, aditya wrote:
In cell A1, data is of 10 digit whose last 6 digit is in form of ddmmyy.
how can i get date, month and year in cell A2 from this.
e.g. Â* Â* Â* Â*A1 Â* Â* Â* Â* Â* Â* Â* Â* Â* Â*A2
Â* Â* Â* Â* UPR/010209 Â* Â* Â* Â*01 FEB 09- Ukryj cytowany tekst -
- Pokaż cytowany tekst -
|