Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Trending Formula Results by Date | Excel Worksheet Functions | |||
formula for filtering and a defaulting date | Excel Worksheet Functions | |||
formula IF returning current date | Excel Worksheet Functions | |||
How do I add a date formula to a cell but hide the contents with . | Excel Discussion (Misc queries) |