| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update Upon Opening based on DATEIF NOW()
Hi All,
If I enter, for example, a birth date in column A1 and the below formula in another column, I understand the result will be someone's age in years, months, and days. My question is: Tomorrow, when I open my file, will my result show one more day added to the "days" number? Thanks for your time. =DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW(),"ym") & " months, " & DATEDIF(A1,NOW(),"md") & " days" -- sherry |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DATEIF function help pleeeeeease | Excel Worksheet Functions | |||
| IF/AND/OR/DATEIF Issue...sorry...long post... | Excel Worksheet Functions | |||
| DATEIF Name error | Excel Worksheet Functions | |||
| DATEIF and IF statements | Excel Worksheet Functions | |||
| CALCULATING DATES AFTER DATEIF | Excel Discussion (Misc queries) | |||
Threaded Mode
