current date formula
 

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

current date formula
 

=IF(A1="no",TODAY(),"")
--
Gary''s Student


"sunderland27" wrote:

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

current date formula
 

Try a formula in the destination cell like

=IF(A1="no",TODAY(),"")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"sunderland27" wrote in
message
...
i want to be able to have the current date populate a field when
another
field is select "no". can anyone help?

current date formula
 

do i put anything in TODAY (?)

"Gary''s Student" wrote:

=IF(A1="no",TODAY(),"")
--
Gary''s Student


"sunderland27" wrote:

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

current date formula
 

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



"sunderland27" wrote in
message
...
do i put anything in TODAY (?)

"Gary''s Student" wrote:

=IF(A1="no",TODAY(),"")
--
Gary''s Student


"sunderland27" wrote:

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

current date formula
 

when i typed in the formula, i got a date "38817"

"Gary''s Student" wrote:

=IF(A1="no",TODAY(),"")
--
Gary''s Student


"sunderland27" wrote:

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

current date formula
 

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 Student


"sunderland27" wrote:

do i put anything in TODAY (?)

"Gary''s Student" wrote:

=IF(A1="no",TODAY(),"")
--
Gary''s Student


"sunderland27" wrote:

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

current date formula
 

when i typed in the formula, i got a date "38817"

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



"sunderland27" wrote in
message
...
when i typed in the formula, i got a date "38817"

"Gary''s Student" wrote:

=IF(A1="no",TODAY(),"")
--
Gary''s Student


"sunderland27" wrote:

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