Using Excel 2003 need to get this right in 2003 then will move to 2010
If today is a weekday and Mon then tell me the most recent date that is a Monday
and therefore if the next day is a Tue then give the most recent prior date that corresponds to Tuesday (note so far observation has shown this to be up to 55 days since the last time that Tues existed in the database)
so :
<tbody>
</tbody>Note that the database currently runs for 3605 lines and increments for the moment manually each day
<tbody>
</tbody>
If today is a weekday and Mon then tell me the most recent date that is a Monday
and therefore if the next day is a Tue then give the most recent prior date that corresponds to Tuesday (note so far observation has shown this to be up to 55 days since the last time that Tues existed in the database)
so :
If today is a weekday and Mon then tell me the most recent date that is a Monday | |
and therefore if we advance today to Wed then give the most recent prior date that corresponds to Wednesday | |
Answer no 1 is | 6/14/1982 |
Answer no 2 is | 5/26/1982 |
<tbody>
</tbody>
Month | Date | Open | High | Low | Close | weekday | red |
Apr | 4/27/1982 | 120.2 | 120.35 | 118.4 | 118.85 | Tuesday | red |
Apr | 4/28/1982 | 118.55 | 119.3 | 117.7 | 118.15 | Wednesday | red |
Apr | 4/29/1982 | 117.5 | 118.15 | 117.25 | 117.6 | Thursday | red |
Apr | 4/30/1982 | 117.55 | 118.4 | 117.4 | 117.5 | Friday | red |
May | 5/3/1982 | 117.1 | 117.5 | 116.8 | 117.15 | Monday | red |
May | 5/5/1982 | 117.85 | 118.3 | 117.05 | 117.55 | Wednesday | red |
May | 5/10/1982 | 119.2 | 119.4 | 118.45 | 118.5 | Monday | red |
May | 5/12/1982 | 119.85 | 120.35 | 119.05 | 119.55 | Wednesday | red |
May | 5/13/1982 | 119.55 | 119.75 | 118.15 | 118.35 | Thursday | red |
May | 5/14/1982 | 118.55 | 118.75 | 118.1 | 118.3 | Friday | red |
May | 5/17/1982 | 118.15 | 118.15 | 116.5 | 116.6 | Monday | red |
May | 5/18/1982 | 116.6 | 116.7 | 115.75 | 116 | Tuesday | red |
May | 5/19/1982 | 115.95 | 116.35 | 114.45 | 114.65 | Wednesday | red |
May | 5/21/1982 | 115.25 | 115.6 | 114.75 | 114.9 | Friday | red |
May | 5/25/1982 | 115.2 | 115.65 | 113.45 | 113.75 | Tuesday | red |
May | 5/26/1982 | 114 | 114.1 | 112 | 112.5 | Wednesday | red |
May | 5/27/1982 | 112.45 | 112.6 | 111.2 | 111.85 | Thursday | red |
May | 5/28/1982 | 111.7 | 112.5 | 110.75 | 111 | Friday | red |
Jun | 6/1/1982 | 110.75 | 111.2 | 109.9 | 110.05 | Tuesday | red |
Jun | 6/3/1982 | 111.65 | 112.05 | 109.7 | 110.5 | Thursday | red |
Jun | 6/4/1982 | 110.4 | 110.45 | 108 | 108.1 | Friday | red |
Jun | 6/8/1982 | 108.35 | 109.4 | 107.3 | 107.8 | Tuesday | red |
Jun | 6/14/1982 | 110.5 | 110.5 | 108.55 | 108.55 | Monday | red |
<tbody>
</tbody>