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...
That won't work.
I fixed it!
Now how do I view only the dates up to December 31st?
Because in this way it also inserts dates after December 31st, up to the cell where the formula was dragged.
Now how do I view only the dates up to December 31st?
Because in this way it also inserts dates after December 31st, up to the cell where the formula was dragged.
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.