Get instant live expert help on I need help with weekdays in a year
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I have the formula =text(weekday(date(calendaryear,1,2),1),”aaa”)
Automatically updates the weekdays in the row according to the year entered in a different cell.
But I also want to automatically update the weekdays in that same row according to the month entered in a different cell(b4). How should I change it my current formula
Solved by O. F. in 18 mins
I have a problem not being able to calculate the Equip Rates, man hauler for weekdays, can only calculate Saturdays. Need to calculate weekdays for equipment since it has a unique way to calculate cost
Solved by M. C. in 29 mins
I have the formula =text(weekday(date(calendaryear,1,2),1),”aaa”)
Automatically updates the weekdays in the row according to the year entered in 'ah' just for January. That's the problem.
I also want to automatically update the weekdays in the row according to the month entered in cell(b4). How should I change it my current formula? I don't want to keep adjusting the Month. =text(weekday(date(calendaryear,I have to keep changing,2),1),”aaa”)
Solved by I. D. in 29 mins
I need the excel document to count weekdays m-f in one column and weekends in another.
Solved by B. B. in 27 mins
I want my formula in Column I to only account for Weekdays, not weekends.
Solved by O. S. in 27 mins