TECH-015 - Count total days by day of the week in a calendar in Excel

YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT www.theexcelchallenge.com
Learn how to count total days by day of the week in a calendar in Excel and how to sum a total value if a value is assigned to each day of the week. You will use the WEEKDAY formula, the VLOOKUP formula, the COUNT formula and the SUM formula, plus other regular Excel tips and tricks.
This is a video that shows the answer to one of the challenges that one of our subscribers was facing.
I hope this concept is something you can use in your daily routine so you get more with less effort.
If you have an Excel challenge that you need help with, whether it is at work, at home, or at school, please write it in the comments below. I try to resolve common Excel challenges from our viewers and subscribers.
Thank you for watching.
Check out some of our previous videos in the links below:
* TECH-014 - Create a progress tracker with check box buttons in Excel • TECH-014 - Create a pr...
* TECH-013 - Create a bar chart with conditional formatting in Excel • TECH-013 - Create a ba...
* TECH-012 - Create links in Excel within your spreadsheet and outside of your spreadsheet
• TECH-012 - Create link...
* TECH-011 - Create a calendar in Excel that automatically updates colors by event category • TECH-011 - Create a ca...

Пікірлер: 8

  • @mlcalderaro
    @mlcalderaro4 жыл бұрын

    You have shown me that excel is absolute magic! Love your videos! Awesome teacher!!

  • @royal-eb4lc
    @royal-eb4lc7 жыл бұрын

    Thank you so much can you show accumulative in the total value ( B2 ) according today's date Maybe by using today function ?

  • @TheExcelChallenge

    @TheExcelChallenge

    6 жыл бұрын

    Hello Royal. Yes, you can show today's accumulative with the TODAY function in whatever cell you need. Just enter: =VLOOKUP(TODAY(),E:I,5,FALSE) in any cell. If today's date is not in your list in column E, you will get an #N/A error. To prevent that, try this in any cell: =IFERROR(VLOOKUP(TODAY(),E:I,5,FALSE),"Today's date is not in the list") If you want the file, I can email it to you. Just send me your email address. Good luck! T-E-CH

  • @royal-eb4lc

    @royal-eb4lc

    6 жыл бұрын

    THANKS. You helped me a lot

  • @TheExcelChallenge

    @TheExcelChallenge

    6 жыл бұрын

    Glad to hear. Thank you for watching. Stay tuned for more videos in the near future. T-E-CH

  • @ExceliAdam
    @ExceliAdam6 жыл бұрын

    If total value is enough and most off values for days of the week are repeated (only friday = 0,5), then you could use this formula: =NETWORKDAYS.INTL(start_date, end_date, "0000100")+0,5*NETWORKDAYS.INTL(start_date, end_date, "1111011") but your formula describes everything nicely and it's easier to change the values assigned to the day of the week

  • @TheExcelChallenge

    @TheExcelChallenge

    6 жыл бұрын

    Thanks for your contribution Excel.i Adam I hope other users can take advantage of your formula. Thanks for sharing. T-E-CH

  • @tahasaid7997
    @tahasaid79973 жыл бұрын

    how to remove the vacanacies days from calender to use it as agantt chart in scheduling of projects