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

Answers