Loading...
Quick Links

Reply To: Weekly Calendar on Visual Reports

Home Forums Discussion Weekly Calendar on Visual Reports Reply To: Weekly Calendar on Visual Reports

#406948

Since the data has been exported to Excel, can you add a column and calculate a week date doing math with dates? Take the year starting week’s date and add 7 times the week number. For example, our starting week date for 2016 was 1/2/16. Therefore the formula on each week would be 1/2/2016 + (7 * (weeknumbercell – 1)). So our week 5 would be 1/2/16 +(7*(5-1)) or 1/2/16 +28 days or 1/30/16.