Hi everyone, I've done a quick search on the site and cant seem to find an answer so I figure I'd throw it out there for an answer. I am creating a workback and trying to minimize clutter. That said- right now I have a cell that calculates days out from today's date. Within that same cell I want to have days/weeks whereby that individual cell calculates days out and the next formula uses that value and divides by 7 to calculate weeks out using that first formula, with the end value resulting something like: “28 / 4” (days out / weeks out). 28 is the first calculation [=IF(F180,F18-TODAY(),"-")] and 4 representing the the results of the first calculation divided by 7.

Any help would be huge!

Many thanks!