How to Count days based on number of dates
In this video, we will learn how to count days based on number of dates.
Excel has got lots of functionality. Imagine a situation wherein you have dates of your customers who visited the store frequently.You want to do a count on which day of the week they have come most.
This is where the crux of the problem stems from.
1. Calculate the day of the week using weekday function
2. Make a helper column
3. Enter the formula to calculate the number of days
Keep Watching,keep learning.
#Exceltipsandtricks #countdays #Weekday