John Ballard 2 Posted February 24, 2020 Share Posted February 24, 2020 I have a bunch of data in Date formate dd/mm/yyyy and I need to sort it by decade. Any help would be appreciated. EDIT: I solved this by going to the data tab>add calculated column> and pasted the following command which binned by data in useable way. Integer(Floor(Year([myDate])/10)*10) I am now going to get taco bell. Link to comment Share on other sites More sharing options...
Andrew Yeck Posted February 24, 2020 Share Posted February 24, 2020 Have you tried the new Taco Bell $10 Nacho Box That might help. Link to comment Share on other sites More sharing options...
John Ballard 2 Posted February 24, 2020 Author Share Posted February 24, 2020 This helped a lot thanks for gold the kind stranger! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now