Excel split month and year from date

SagarSB · July 18, 2018, 12:41pm

yes…see above screenshot

SagarSB · July 18, 2018, 12:43pm

please use this fileExcel.xlsx (136.2 KB)

SagarSB · July 18, 2018, 12:51pm

Can anyone provide me solution with this file for split month and year and write them into respective columns…

Excel.xlsx (136.2 KB)

Thanks in advance

indra · July 18, 2018, 1:12pm

@SagarSB check attached updated zip file SplitDateFromExl.zip (45.3 KB)

SagarSB · July 18, 2018, 1:15pm

ok thank you…i will check it and let you know

PrankurJoshi · July 19, 2018, 5:47am

Attached is the updated file

Excel.xlsx (121.0 KB)

Topic		Replies	Views
Split month and year from them and write into respective columns Help	11	1695	October 29, 2018
Excel data mapping Help	5	1660	October 29, 2018
Extract number from date Help	13	1216	August 4, 2020
Extract data from the excel of the input month Help datatable , excel , activities , question	8	895	January 8, 2020
Get only Month and Year from Variable Help	6	2439	August 27, 2019