| Home |
| Search |
| Today's Posts |
|
|
|
#1
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) | |||
Hybrid Mode
