Get instant live expert help on I need help with excel vba weekday

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I have a problem regarding to Excel WEEKDAY Function
Solved by O. B. in 30 mins
Solved by I. C. in 24 mins
I need to convert date to a number, using weekday function. For example, with 13/5/2015, the weekday function doesn't work and shows #value error message.
Solved by K. L. in 25 mins
Attached is an excel sheet which compares Weekday versus Weekend ADR. It starts in 2010 and ends in 2017. I need a line graph with 2 lines that shows these comparisons. It should be titled ADR and show which color of the line equates to either weekday or weekend.
Solved by A. C. in 22 mins
=C3-WEEKDAY(C3,1)+2+7*(G3-1) can you please help understand this formula
Solved by C. Q. in 22 mins