Forum Discussion
Automatic entry of times based on conditions
Hello everyone. For weeks now, I've been going crazy looking for a way to solve the problem I'm about to present to you. I have attached the sheet I prepared. In the "HOUR" column there is a...
In C5:
=IF(C4="", "", IF(D4="", IF(YEAR(C4+1)<>$B$1, "", C4+1), IF(D4>TIME(18,0,0), IF(YEAR(C4+1)<>$B$1, "", C4+1), C4)))
In D5:
=IF(C5="", "", IF( WEEKDAY(C5,1)<>1, "", INDEX(IF(OR(MONTH(C5)={7,8}),N$4:N$5,IF(AND(C5>=M$1,C5<M$2),M$4:M$7,L$4:L$7)),COUNTIF(C$3:C5,C5))))
Fill down.
Since I added other conditions, I modified the formulas.
So now what would the formula you wrote above look like?
You'll have to work that out yourself, it's getting too complicated for me.