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