Based on A2 Date take value from B2 and show that value as “ones” spread across columns in same row

Based on a date in A2 I’m trying to take the value in B2 and spread that value in different columns within the same row and show that value as “ones”. I also want the ones to start counting in the correct column (who’s column heading matches the date in A2). Is there an excel formula that will output the “ones” as desired? See below for an example.

A B C D E F
Anticipated
1 Date Req’d Review Time 9/30/13 10/1/13 10/2/13 10/3/13
2 9/30/13 5 1 1 1 1 3 10/1/13 2 1 1
4 10/3/13 6 1
5 10/5/13 4
6 10/6/13 3
7 10/9/13 5

Leave a Reply

Your email address will not be published. Required fields are marked *