Another Date issue.

[Guest]

Yesterday I posted a question about auto filling the date in a field (posted
bellow). Well today to my dismay all those dates advanced to todays date. Is
there another formula that can be used to auto fill in the date and not
advance to the next days date when the sheet is reopened. Also Hope fully
some one will be able to answer the rest of my second question asked
yesterday (also posted below).

By the way '=IF(OR(E2={1,2,3}),TODAY(),"")' works great (except for the
advancing of the date thing mentioned above) I would of never been able to
come up with such a formula on my own.
--
Thanks
TimM

Ok here goes. This is how I have the counting side of it set up, it's almost
like a report of how i'm doing.

Call Type
1 2 3 0
First Level Ticket MP7 Nothing
Resolve Created Ticket Done

Amount of each type Date
16 23 3 1 14-Nov
15-Nov
16-Nov
17-Nov
....
And what I want is it to count each type when I enter them into column F but
i want it to count by the date so when i have 50 different lines all for say
11-14-05 it will cout the 1 and 2 and 3 and 0 for that specfic date then on
11-15-05 it will count all thie lines for that date. Hope this clairify's
--
Thanks
TimM

Try this for your first question:

=IF(OR(E2={1,2,3}),TODAY(),"")

Enter in A2, and copy down as needed.

Re-phrase your second question.

 

[Skin Paul]

Hi, Hope this is what you require
Date Stamp =IF(ISBLANK(A2),"",IF(B2="",TODAY(),B2))
An entry into A2 will put today's date into B2, when the next day arrives,
The date will not change. Any problems Repost or email me.
Paul