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
=C3-WEEKDAY(C3,1)+2+7*(G3-1) can you please help understand this formula
Solved by C. Q. in 22 mins
Hi, I need an IF(OR) formula that takes one column (A) which I have days of the week and will label in another column(B) weekday or weekend if Column(A) was a weekday or weekend. Thanks!
This formula from MS excel is giving an error in Google sheets =DATE(AB3,INDEX({1,2,3,4,5,6,7,8,9,10,11,12},MATCH(AB2,monthNames,0)),1) =IF(C7="","",INDEX({"Su";"M";"Tu";"W";"Th";"F";"Sa"},WEEKDAY(C7,1)))