If Date=x then do y

  • Thread starter Thread starter TruffleShuffle
  • Start date Start date
T

TruffleShuffle

Ok heres my problem, i'm creating a workout schedule for the next coupl
of weeks and part of this will be an archive of my previous results so
can see how i'm progressing.

This consists of 3 worksheets (one for each workout day) where i hav
my target weights and reps, and also a space for me to enter in what
actually lifted.

I would like Excel to automatically copy the current days workou
results from one worksheet to the archive worksheet for starters (not
problem).

The problem occurs cuase i dont want it to ovewrite the data when th
next week comes around and i enter in what i managed then.

I've managed to make formulas which say:
=IF(DATE(2005,7,28)=37099,'Day 1'!G12,"bob")

but obviously that date is ALWAYS going to equal that serial. I want i
to look at the system date, if the date is X the it puts the result
into cell Y if the date is X1 then it puts the results in Y1 etc etc.

I've been looking up and down excel for most of the afternoon and m
eyes are starting to bleed i'm sure of it.

If anyone can help me out i would be very greatfull
 
but obviously that date is ALWAYS going to equal that serial.

What you may be asking for is the TODAY() function which will return the
current system date. You will have the make the formula >=TODAY() otherwise
it will fail on every day after that date as it did on the days before the
date.
to look at the system date, if the date is X the it puts the results
into cell Y if the date is X1 then it puts the results in Y1 etc etc.
Click to expand...

A formula cannot *put* a value in any cell except the one that the formula
is in. You will therefore have to have the appropriate formula in the cells
that you want the values to appear in.

--
HTH

Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk


"TruffleShuffle"
 
Back
Top