Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 04-16-2019, 06:00 AM
ArviLaanemets ArviLaanemets is offline Date Filter in Excel not grouping by month Windows 8 Date Filter in Excel not grouping by month Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

You get not dates, but datestring texts. The reason is, that the date format in your windows regional settings is different from format used in web page (in web page the format is "dd/mm/yyyy" - I don't know is it US or UK format, but it is sure in your computer it must be different. E.g. for me the short date format is "dd.mm.yyyy", and I see the 1st date in column A (the date you obviously reentered) in this format. All other dates are for me strings.

I could easily convert all those strings to dates - I selected the column A, and replaced all "/" with "." (i.e. with my date delimiter).
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date Filter in Excel not grouping by month Auto update excel graph range, ignore data when date reads 00-Month-00 SavGDK Excel 2 06-24-2016 08:05 AM
Excel day date month year Function greginky Excel 1 01-05-2016 02:19 AM
Date Filter in Excel not grouping by month Filter by a Month that falls within a date range MattG1225 Excel 2 12-03-2015 07:44 AM
Date Filter in Excel not grouping by month Pivot table date grouping differentdrummer Excel 2 12-04-2013 03:07 PM
Date Filter in Excel not grouping by month Group by Baseline month view - Incorrect task grouping stct Project 1 04-01-2013 12:43 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:59 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft