Hello, I am creating a Safety Audit Database. Similar to Scheduling principles, we keep track of all data entries by two dates. ACTUAL DATE and WEEK ENDING DATE (where Week Ending date is Sunday)
We use a formula in Excel to do this but I am not able to replicate such formula in smartsheet.
Does anyone know how to do this? change an actual date from one column to a WEEK ENDING into another column. This way I can TIE all DATA based on Project and Week Ending Date to match all of our current reporting.
The formula in Excel is:
=(7-WEEKDAY(A1,2))+A1
Any help is appreciated.
Thanks,