Forum Discussion
Solved
Automatic entries in cells based on a date range
Looking for help creating a formula that will do the following - Column A is start date Column B is an end date Column C is a number The rest of the columns are dates that I want the number in c...
In D2:
=IF(AND(D$1>=$A2,D$1<=$B2),$C2,"")
Fill down and to the right (or vice versa).
See the attached workbook.
In D2:
=IF(AND(D$1>=$A2,D$1<=$B2),$C2,"")
Fill down and to the right (or vice versa).
See the attached workbook.
Thanks so much! saved me a lot of time
