the date is more than 365

the question is to know the value of cell 200 using vloop up function

solve now the what is the value of cell 50 using vloop up

pls do in steps in excel so i can solve the question

2.create a scatter plot of assault y(axis) vs temperature x(axis) what does it look like

pls also do in steps

Q349 E F B C D 1 Dates Day of Week Assaults Temp_max 2 1/1/2005 Saturday 3 1/2/2005 Sunday 4 1/3/2005 Monday 5 1/4/2005 Tuesday 6 1/5/2005 Wednesday 7 1/6/2005 Thursday 8 1/7/2005 Friday 9 1/8/2005 Saturday 1/9/2005 Sunday 1/10/2005 Monday 12 1/11/2005 Tuesday 13 1/12/2005 Wednesday 14 1/13/2005 Thursday 15 1/14/2005 Friday 1/15/2005 Saturday 1/16/2005 Sunday 118 1/17/2005 Monday 1/18/2005 Tuesday 20 1/19/2005 Wednesday 23 1/20/2005 Thursday The LED non C D E B 21 1/20/2005 Thursday 22 1/21/2005 Friday 23 1/22/2005 Saturday 24 1/23/2005 Sunday 25 1/24/2005 Monday 26 1/25/2005 Tuesday 27 1/26/2005 Wednesday 28 1/27/2005 Thursday 29 1/28/2005 Friday 30 1/29/2005 Saturday 31 1/30/2005 Sunday 1/31/2005 Monday 2/1/2005 Tuesday 34 2/2/2005 Wednesday 2/3/2005 Thursday 36 2/4/2005 Friday 37 2/5/2005 Saturday 2/6/2005 Sunday 2/7/2005 Monday 2/8/2005 Tuesday 2/9/2005 Wednesday C E B 2/9/2005 Wednesday 42 2/10/2005 Thursday 43 2/11/2005 Friday 44 2/12/2005 Saturday 45 2/13/2005 Sunday 46 2/14/2005 Monday 47 2/15/2005 Tuesday 48 2/16/2005 Wednesday 49 2/17/2005 Thursday 50 2/18/2005 Friday 51 2/19/2005 Saturday 2/20/2005 Sunday 2/21/2005 Monday 2/22/2005 Tuesday 2/23/2005 Wednesday 2/24/2005 Thursday 2/25/2005 Friday 2/26/2005 Saturday 2/27/2005 Sunday 2/28/2005 Monday 31 2005 Tuesday