Printable View
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.
All the dates fall between start and finish will insert a value on cell below. I have attached the workbook.Code:=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","")
Thank you.
Just a quick response as I am on my way out.
Give this a go for the formula...
I hope this helps!Code:"=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"","""")"
I received an error message after entering your formula. It is pointing at ""1.1"".
Sorry, I think I know what you mean now. I got it to work. Thanks
Yes, sorry about that HawaiianD,
I was in a rush because I was going out.
I am glad it works and you are welcome.
Thanks for the feedback :yes.