=C3-WEEKDAY(C3,1)+2+7*(G3-1)
can you please help understand this formula
Solved by C. Q. in 22 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
To find off-days of employees, based on date and weekday.