Formula

R

Rachel.

I want to enter a formula that draws totals from another spreadsheet (which I
can do, so far). Now the tricky part, I don't want it to enter that number
until a specific date. Ex. 2008/2009 2nd Quarter total does not show up in
the new spreadsheet until the end of the 2009/2010 - 2nd Quarter (Sept 30 or
Oct 1).
 
M

Max

Maybe something like this, in say Sheet1's E2:
=IF(TODAY()<--"1 Oct 2009","",SUM(Sheet2!A1:B1))

Replace: SUM(Sheet2!A1:B1)
with your formula

This front part of the IF:
=IF(TODAY()<--"1 Oct 2009","", ...
will ensure that "nothing happens" until 1 Oct 2009

Yes? Click YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to carry forward a total from one page to another 3
date into current and previous quarters 3
Still trying to average 4 worksheets and having formula problems 3
week entry 1
Formula for Dates 3
Averaging cells in separate workbooks to make year-to-date average 7
SUMIF Formula Help 8
Excel Tables - Cross tbl tp Reg tbl 2

Top