mercredi 25 février 2015

Excel VBA isolate Unique dates when you have time with it

I am looking to create an array or range of unique dates from a column of dates that have time associated with it. For example



1/3/1984 0:15
1/3/1984 0:20
1/4/1984 0:25
1/4/1984 0:30
1/6/1984 0:35
1/6/1984 0:40


The range would return



1/3/1984
1/4/1984
1/6/1984


Thanks for any help!


Aucun commentaire:

Enregistrer un commentaire