Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to sum up the days and I am struggling.
My date format is M/D/YYYY
1/29/2022
1/31/2022
2/4/2022
2/4/2022
1/29/2022
How can I sum up the days?
HI
Then you can use
Count(Dates) -- it gives no. of occurrence.
Hi
Do u want to count the dates?
If so, try like Count(Distinct Dates)
Hi
No, I don't want to count the dates because it gives me just 1 for each date.
Wherever the days are the same:
1/4/2022
3/4/2022
I want it to give me 2 instead of each date.
HI
Then you can use
Count(Dates) -- it gives no. of occurrence.