Rounding down based on week ending date?

shonda.vanzandt

Hello,

I am trying to recreate this formula from Excel into my Smartsheet:

=ROUNDDOWN((DATEDIF([@[Leave Date]],[@[Week Ending]], "d") / 7), 0)

It is supposed to subtract 7 days from the Week Ending date.

How can I make this work in Smartsheet?

ron.judenberg112096

try

=FLOOR(NETDAYS([Leave Date]@row, [Week Ending]@row) / 7, 1)