software

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
--
wynbquot;tjtjjtjtquot; wrote:

gt; How about putting this in Q1:
gt; =IF(Q80=quot;closedquot;,NOW(),quot;quot;)
gt; Keep in mind that NOW() returns the current date and updates every time the
gt; spreadsheet recalculates. So, if you type quot;closedquot; in Q80 on 3/25/2006 and
gt; then open the workbook on 3/26/2006, the date in Q1 will be 3/26/2006.
gt;
gt; If you need a static date, take a look at:
gt; www.mcgimpsey.com/excel/timestamp.html
gt; This will get you started developing a solution.
gt;
gt; --
gt; tj
gt;
gt;
gt; quot;WYNquot; wrote:
gt;
gt; gt; good day all,i need a formula to do the following.=if(q80=closed,q1=now())
gt; gt; i want q1 to show the date by entering the word closed in cell q80? any help
gt; gt; is appreciated.
gt; gt; --
gt; gt; wynb