Topics Topics Help/Instructions Help Edit Profile Profile Member List Register Paatha Gnyapakaalu - Archives from Old DB  
Search New Posts 1 | 2 | 8 Hours Search New Posts 1 | 3 | 7 Days Search Search Tree View Tree View Latest tweets Live Tweets   Hide Images

Rate this post by selecting a number. 1 is the worst and 5 is the best.

    (Worst)    1    2    3    4    5     (Best)

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this message

Blazewada
Celebrity Bewarse
Username: Blazewada

Post Number: 25900
Registered: 08-2008
Posted From: 58.182.87.144

Rating: N/A
Votes: 0

Posted on Friday, February 19, 2016 - 9:29 am:   
Kalikaalam:


a qq: after splitting the date , there are 3 columns one each for date, month and year. How did you replace the date value with the values from column_A?




E1: YEAR_SPLIT
D1: MONTH_SPLIT
B1: DATE_REPLACE (new value)

=DATE(E1,D1,B1)
जिसको ढूंढे बाहर बाहर - वो बैठा है भीतर छुप के

Topics | Last Hour | Last Day | Last Week | Tree View | Search | Help/Instructions | Program Credits Administration