software

i want to be able to have the current date populate a field when another
field is select quot;noquot;. can anyone help?

=IF(A1=quot;noquot;,TODAY(),quot;quot;)
--
Gary''s Studentquot;sunderland27quot; wrote:

gt; i want to be able to have the current date populate a field when another
gt; field is select quot;noquot;. can anyone help?

Try a formula in the destination cell like

=IF(A1=quot;noquot;,TODAY(),quot;quot;)--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.comquot;sunderland27quot; gt; wrote in
message
...
gt;i want to be able to have the current date populate a field when
gt;another
gt; field is select quot;noquot;. can anyone help?
do i put anything in TODAY (?)

quot;Gary''s Studentquot; wrote:

gt; =IF(A1=quot;noquot;,TODAY(),quot;quot;)
gt; --
gt; Gary''s Student
gt;
gt;
gt; quot;sunderland27quot; wrote:
gt;
gt; gt; i want to be able to have the current date populate a field when another
gt; gt; field is select quot;noquot;. can anyone help?

gt; do i put anything in TODAY (?)

No. The TODAY() function takes no arguments and returns the
current date.--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
quot;sunderland27quot; gt; wrote in
message
...
gt; do i put anything in TODAY (?)
gt;
gt; quot;Gary''s Studentquot; wrote:
gt;
gt;gt; =IF(A1=quot;noquot;,TODAY(),quot;quot;)
gt;gt; --
gt;gt; Gary''s Student
gt;gt;
gt;gt;
gt;gt; quot;sunderland27quot; wrote:
gt;gt;
gt;gt; gt; i want to be able to have the current date populate a field
gt;gt; gt; when another
gt;gt; gt; field is select quot;noquot;. can anyone help?
when i typed in the formula, i got a date quot;38817quot;

quot;Gary''s Studentquot; wrote:

gt; =IF(A1=quot;noquot;,TODAY(),quot;quot;)
gt; --
gt; Gary''s Student
gt;
gt;
gt; quot;sunderland27quot; wrote:
gt;
gt; gt; i want to be able to have the current date populate a field when another
gt; gt; field is select quot;noquot;. can anyone help?

No, TODAY() needs no argument.

HOWEVER...be sure to format the cell as date, otherwise you will see:
38817(sorry I didn't warn you)
--
Gary's Studentquot;sunderland27quot; wrote:

gt; do i put anything in TODAY (?)
gt;
gt; quot;Gary''s Studentquot; wrote:
gt;
gt; gt; =IF(A1=quot;noquot;,TODAY(),quot;quot;)
gt; gt; --
gt; gt; Gary''s Student
gt; gt;
gt; gt;
gt; gt; quot;sunderland27quot; wrote:
gt; gt;
gt; gt; gt; i want to be able to have the current date populate a field when another
gt; gt; gt; field is select quot;noquot;. can anyone help?

gt; when i typed in the formula, i got a date quot;38817quot;

That is the date serial number (the way Excel internally stores
dates, the number of days since 0-Jan-1900). Format the cell for
Date and all will be right in your world.--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
quot;sunderland27quot; gt; wrote in
message
...
gt; when i typed in the formula, i got a date quot;38817quot;
gt;
gt; quot;Gary''s Studentquot; wrote:
gt;
gt;gt; =IF(A1=quot;noquot;,TODAY(),quot;quot;)
gt;gt; --
gt;gt; Gary''s Student
gt;gt;
gt;gt;
gt;gt; quot;sunderland27quot; wrote:
gt;gt;
gt;gt; gt; i want to be able to have the current date populate a field
gt;gt; gt; when another
gt;gt; gt; field is select quot;noquot;. can anyone help?