DATE FROM ANOTHER COLUMN GOES TO THE NEXT FRIDAY
I want to use the date from a column and when there is a date in that column to make the date in the next column the friday in the next week.
Column A - Arrives at Port 7/1/20 (This is the date column A actually is)
Column B - Inventory Received 7/10/20 (This is the date I want column B to reflect in real time from a formula)
Column B= The Friday of the following week based on the date in Column A (I do not want it to be the Friday in the current week.
Is there a formular or a way to create this in Smart Sheets
Any help would be greatly apprecaited
Help Article Resources
Check out the Formula Handbook template!