You have shown me that excel is absolute magic! Love your videos! Awesome teacher!!
@ExceliAdam
6 жыл бұрын
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
6 жыл бұрын
Thanks for your contribution Excel.i Adam I hope other users can take advantage of your formula. Thanks for sharing. T-E-CH
@royal-eb4lc
7 жыл бұрын
Thank you so much can you show accumulative in the total value ( B2 ) according today's date Maybe by using today function ?
@TheExcelChallenge
7 жыл бұрын
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
7 жыл бұрын
THANKS. You helped me a lot
@TheExcelChallenge
7 жыл бұрын
Glad to hear. Thank you for watching. Stay tuned for more videos in the near future. T-E-CH
@tahasaid7997
3 жыл бұрын
how to remove the vacanacies days from calender to use it as agantt chart in scheduling of projects
Пікірлер: 8