vk7
Member
Hello Excel Gurus,
I have attached a excel file, where I have a timestamp field.. Inorder to make a pivot out of the timestamp field, I need to split the timestamp field to have only year-mm therefore in another column, I am planning to have yyyy-mm field but I am unable to split this information from the timestamp. I tried using the formula '=TEXT(A1, "yyyy-mm")' but it doesn't help. Can someone help me out? The end goal is to figure out the total count for each month and year by looking at the timestamp.
I have attached a excel file, where I have a timestamp field.. Inorder to make a pivot out of the timestamp field, I need to split the timestamp field to have only year-mm therefore in another column, I am planning to have yyyy-mm field but I am unable to split this information from the timestamp. I tried using the formula '=TEXT(A1, "yyyy-mm")' but it doesn't help. Can someone help me out? The end goal is to figure out the total count for each month and year by looking at the timestamp.