Calculating Weeks out from a date

Crystal Panning
Crystal Panning ✭✭✭✭
edited 12/09/19 in Smartsheet Basics

I am trying to calculate weeks out from a set date, and figured out a way, but wondering if there is an easier way without having a helper column (Days Diff column). The below columns is what I have: 

Weeks Out    Day Diff    Start Date

I have 2 formulas: 

In the Day Diff column I have =NETDAYS([Start Date]1, [Set Date]$109)

I then have a formula in the Weeks Out column that takes the day amount in the Day Diff column and divides by 7 to get the weeks out. 

    =[Day Diff]1 / 7

This works and gives me my weeks out, but is there a formula that can calculate the weeks out from the Start Date to the Set Date without using the Day Diff column? 

Thank you,

Crystal

Comments