D DonVman New Member Apr 30, 2018 #1 Hello, I am working on trying to figure out the correct IF statement syntax for the differences between dates so I can plot these to a dynamic stacking chart (see pic). I have supplied a sample of what I am trying to accomplish. I hope this makes sense. Attachments Excel Sample.xlsx 15.1 KB · Views: 2 Sample.png 155.8 KB · Views: 7
Hello, I am working on trying to figure out the correct IF statement syntax for the differences between dates so I can plot these to a dynamic stacking chart (see pic). I have supplied a sample of what I am trying to accomplish. I hope this makes sense.
H Haz Active Member Apr 30, 2018 #2 Are the auditions always in order, 1 < 2 < 3 < 4? In that case you can use the MAX instead of checking for each date. Attachments Excel Sample.xlsx 14.7 KB · Views: 4
Are the auditions always in order, 1 < 2 < 3 < 4? In that case you can use the MAX instead of checking for each date.
D DonVman New Member Apr 30, 2018 #3 Yes, that's fantastic and works perfectly. Many thanks for your assistance.
