This... IF(WEEKDAY(A1)=7,7,7)... will always return 7... why not just use 7
and save the function calls?

a

--
Rick (MVP - Excel)


"Mike H" wrote in message
...
Hi,

If I understand correctly you want the next saturday from a date and if
the
date is saturday and you want the folowing saturday change the middle 7 to
14

=A1+IF(WEEKDAY(A1)=7,7,7)-WEEKDAY(A1)

Mike

"Dylan @ UAFC" wrote:

I am needing a formula that will returna week ending date
based, this is primary way the data base needs to be sorted.

Or week ends on SAT