jojo3strada
New Member
- Joined
- Feb 20, 2024
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
I am spending a long time on this spreadsheet and there is gotta be a better way. I have the delivery date, duration weeks, return date. I need a rule or something that can automatically put a 1 on the weeks date on the right till it hits the end of weeks duration
Delivery Date | Expected Duration (Weeks) | Expected Return (Date) | 02/19/24 | 02/26/24 | 03/04/24 | 03/11/24 | 03/18/24 | 03/25/24 | 04/01/24 | 04/08/24 | 04/15/24 | |
2/19/2024 | 37 | 11/4/2024 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |
2/19/2024 | 15 | 6/3/2024 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |
2/19/2024 | 46 | 1/6/2025 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |
2/19/2024 | 37 | 11/4/2024 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |
2/19/2024 | 17 | 6/17/2024 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |