Get instant live expert help on I need help with excel weekday function
“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 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
Can you subtract a date from another date to see how many days late something is, whilst using the weekday function?
Here is the function currently have.
=IF(OR(ISBLANK(B3),ISBLANK(P3)),"",P3-B3)
Solved by E. E. in 26 mins
In cell J10, enter an INDEX function that will convert the Call Day to the actual weekday found in row 1 of the DayofWeek named range. Resize the column width excel vba as needed.
Solved by T. D. in 12 mins
=Project_Start-WEEKDAY(Project_Start,1)+2+7*(Display_Week-1)
Solved by I. C. in 24 mins
I need to find an INDEX function that will convert the Call Day (a number 1-7) to the actual weekday found in row 1 of the DayofWeek named range. I don't know if I'm supposed to use the MATCH function as well or not.
Solved by D. D. in 16 mins