Hi guys,
just wondering how i can get the data from column I and feed show it in column C depending on the date if it is less than or equal to date. i need july 31 - Aug 4 to show 994, then, aug 5-6(weekend) would be 0, then Aug 7 - 11 1235, then 0 again for Aug 12 and 13 since its weekend.
just wondering how i can get the data from column I and feed show it in column C depending on the date if it is less than or equal to date. i need july 31 - Aug 4 to show 994, then, aug 5-6(weekend) would be 0, then Aug 7 - 11 1235, then 0 again for Aug 12 and 13 since its weekend.
| Book1 | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| B | C | D | E | F | G | H | I | |||
| 1 | Data | |||||||||
| 2 | 31-Jul | Clean | ||||||||
| 3 | 1-Aug | 31-Jul | 994 | |||||||
| 4 | 2-Aug | 7-Aug | 1235 | |||||||
| 5 | 3-Aug | 14-Aug | 1236 | |||||||
| 6 | 4-Aug | 21-Aug | 850 | |||||||
| 7 | 5-Aug | 28-Aug | 425 | |||||||
| 8 | 6-Aug | 4-Sep | 485 | |||||||
| 9 | 7-Aug | |||||||||
| 10 | 8-Aug | |||||||||
| 11 | 9-Aug | |||||||||
| 12 | 10-Aug | |||||||||
| 13 | 11-Aug | |||||||||
Sheet1 | ||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| B3:B13 | B3 | =B2+1 |
