— CAN YOU SOLVE THIS - EXCEL CHALLENGE 157 —
(Solutions in any language are also welcome for Excel Challenges)
Find the number of workdays between two dates (From & To) for Weekends given in column E.
Blank in To field means Current Date.
Blank in Weekend field means Sat, Sun.
The answers shown where To dates are blanks are for 23-Mar-2023. Hence, your answer for these rows may differ.
The dates are in US format, so depending upon your locale, you may need to convert column C and D in your locale’s date format before making the formula.
Post answers in Comment.
(Your formula need not be a single formula. You can write multiple formulas to arrive at a solution. Also your formula need not be different from others as long as you have worked out your formula independently)
Download Practice File - https://lnkd.in/dPtaaQJ7
#excel, #excelchallenge, #powerquerychallenge, #daxchallenge, #m, #dax, #powerbi, #powerquery, #powerpivot, #sheets, #googlesheets, #data, #analytics, #businessintelligence, #finance, #office365, #python, #r
Excel BI’s LinkedIn Post