I'm just learning Excel beyond the basics so this is a newbie question. I have some raw data from a download of the date and time that people signed up to a training course my organisation put on. I'm looking to count how many sign ups happened on each date of a two month period before cross referencing that with a number of dates we sent out promotional sign up emails to see how effective our email campaigns were.
Given the sparse basic nature of the data with date and time in one cell, I first of all seperated the date out as I'm not worried about the time. I did this by using the Integer function and then formatting the new column to date format to give me the date as in picture 1. These were then all individual signups that needed to be counted.
Then I sorted all of them into date order and wanted to count how many sign ups were received on the start date using =countif,(range,"19/07/2022") Whilst this worked for the first few dates I entered manually, it would not automatically fill down. Instead flashfill just repeated the outcomes of the first few cells. Instead I ended up doing the counts for each day manually and entering them manually too as in picture 2.
Can somebody advise on how I should have approached this instead? I know this should have taken 2 minutes and instead it took me 45.
Given the sparse basic nature of the data with date and time in one cell, I first of all seperated the date out as I'm not worried about the time. I did this by using the Integer function and then formatting the new column to date format to give me the date as in picture 1. These were then all individual signups that needed to be counted.
Then I sorted all of them into date order and wanted to count how many sign ups were received on the start date using =countif,(range,"19/07/2022") Whilst this worked for the first few dates I entered manually, it would not automatically fill down. Instead flashfill just repeated the outcomes of the first few cells. Instead I ended up doing the counts for each day manually and entering them manually too as in picture 2.
Can somebody advise on how I should have approached this instead? I know this should have taken 2 minutes and instead it took me 45.