Re: If statemenet to determine hours worked per week
Quote from NBVC;709012
So they can enter a date in column A? Just not in the format of 4/7? If they can enter a date (no matter the format), the calculations in my formula should still work.
I am a little confused about the "real" problem.
They can enter a date, but it has to be entered at "7 APR 2014" and other method excel rejects. It seems that Excel does not recognize it as a date and does not allow the formuals to work to calculate the hours worked per week.