Ranggas Prima Utama
Reputation: 1
Formula to add numbers on a date and turn to a specific day
In cell A1 i have stock date. In cell A2 is the ship date which is every Saturday on the same week. What is the formula so that any date in cell A1 will turn to Saturday on the same week of cell A2?
Upvotes: 0
Views: 31
Answers (1)
Related Questions
- Adding numbers of date to single digit
- How to calculate date by adding number of weekdays to a input date
- Ms excel - how do I add 1 day to my custom date?
- Formula to calculate dates
- Calculate day from date in excel
- Conditionally adding day to previous date in column
- How to add multiple values based on a date range displayed per day
- How To Calculate Date From Day Number In Excel
- Adding variable number of days to dates
- Excel formula to work out days