Hi tj, that works a treat.you are right about the date changing each time the
sheet recalculates,a static date would be better.i will the the web address
you added.thanks again wynb
--
wynb


"tjtjjtjt" wrote:

How about putting this in Q1:
=IF(Q80="closed",NOW(),"")
Keep in mind that NOW() returns the current date and updates every time the
spreadsheet recalculates. So, if you type "closed" in Q80 on 3/25/2006 and
then open the workbook on 3/26/2006, the date in Q1 will be 3/26/2006.

If you need a static date, take a look at:
http://www.mcgimpsey.com/excel/timestamp.html
This will get you started developing a solution.

--
tj


"WYN" wrote:

good day all,i need a formula to do the following.=if(q80=closed,q1=now())
i want q1 to show the date by entering the word closed in cell q80? any help
is appreciated.
--
wynb