Calculating Weeks out from a date
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?