Forum Discussion
Distinct dates from specific date until today
I want to calculate the number of unique dates from a given date until today. Does anyone know how I can achieve this?
Let's say this is the data.
| Name | Date |
| X | 26-6-2021 |
| Y | 27-6-2021 |
| Z | 29-6-2021 |
| X | 20-7-2021 |
| Y | 23-7-2021 |
| Z | 24-7-2021 |
I want to count the the number of unique dates for X, Y or Z from the first available date until today.
Hi Anonymous ,
Counting unique dates against a name is easy as shown below:
As you haven't attached the expected output along with the input, I will ask again what do you mean by - from the first available date until today ?
Thanks,
Pragati