HawaiianD
04-20-2016, 07:37 PM
Hi guys,
I currently have a formula to plot values if the date is within a certain range. I would need help to convert the formula into VBA.
=IF(AND(C$1>=INT($O7),C$1<=INT($P7)),"1.1","")& IF(AND(C$1>=INT($Q7),C$1<=INT($R7)),"1.2","")&IF(AND(C$1>=INT($S7),C$1<=INT($T7)),"1.3","")
All the dates fall between start and finish will insert a value on cell below. I have attached the workbook.
Thank you.
I currently have a formula to plot values if the date is within a certain range. I would need help to convert the formula into VBA.
=IF(AND(C$1>=INT($O7),C$1<=INT($P7)),"1.1","")& IF(AND(C$1>=INT($Q7),C$1<=INT($R7)),"1.2","")&IF(AND(C$1>=INT($S7),C$1<=INT($T7)),"1.3","")
All the dates fall between start and finish will insert a value on cell below. I have attached the workbook.
Thank you.