Date format issue solved - filter not showing year and month of dates in Excel #msExcel #shorts

preview_player
Показать описание
Sometimes when you download Google Sheet as an Excel file then the date is shown as text in Excel.
If you apply a filter on this date column then dates will not be grouped into years and months.
This video explains how to overcome date formatted as a text issue in Excel.

🌐 Websites 🌐

📌📌You can watch and learn from the below videos also.📌📌


#learnyouandme #msExcel
Рекомендации по теме
Комментарии
Автор

Calculate expiry dates in Excel | Expiry date after N months, N days & N years in Excel

LearnYouAndMe
Автор

Jabardast kya ye formula google sheet pe bhi kaam krega

Sagarkumar-qjhl
Автор

ये तो सही है but जब डेटा जब month wise फ़िल्टर करते हैं तो ये date ko month consider krta hai jaise maine january ko filter kiya to usme 01-05-2023 bhi aa gya kyuki wo 01 ko january count krta hai or 05 ko date consider krta hai iska kya solution hai

Sagarkumar-qjhl
visit shbcf.ru