On Mon, 9 Apr 2012 21:32:00 +0000, Tusa123 wrote:


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!

You can't really use the result of one formula in the next, and display both values. At least, I don't know how using worksheet functions. But you could concatenate the two formulas. Be aware, though, that the result will be a text string; not something easily used in a subsequent formula. e.g:

=IF(F180,F18-TODAY(),"-") & " / " & IF(F180,ROUND((F18-TODAY())/7,1),"-")