Hello Good day Masters. I need your help with filters. Is it possible to filter the Month and Day (Sun - Sat) which info in the same cell?
If not, what's the alternative? kindly see attached excel file for reference. thank you so much.
filter.PNG
Hello Good day Masters. I need your help with filters. Is it possible to filter the Month and Day (Sun - Sat) which info in the same cell?
If not, what's the alternative? kindly see attached excel file for reference. thank you so much.
filter.PNG
In B6 copied down:
=WORKDAY.INTL(DATE(2019,2,1),ROWS(A$1:A1)-1,1)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hello Ali. What I mean is that is there a possible way to filter the day (Weekdays and Weekends) without making another column for it? or do I need to make another column just to separate the date and the day?
No - you'll have to create a helper column. But if you don't want weekends, then create the list without them as I showed you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks