| Home |
| Search |
| Today's Posts |
|
#6
|
|||
|
|||
Just curious. Which one???
PhilS wrote: You are correct. Your suggestion worked immediately. Thank you very much. PhilS "Dave Peterson" wrote: It always scares me when I see dates as strings. I'd use this: =DATEDIF(DATE(2004,12,31),TODAY(),"d") Just in case the windows regional settings for short dates wasn't mdy. But when I changed my windows regional settings, I got a #value! error with your original formula. Another international question... Are you sure that "D" is the correct representation for Day in your installed version of excel. (difficult to guess where you're located). Heck, maybe =datedif() is different in your installed language. If you do this: hit alt-f11 to get to the VBE hit ctrl-g to see the immediate window type this and hit enter: range("a1").formula = "=DATEDIF(DATE(2004,12,31),TODAY(),""d"")" what formula do you see in A1 of that activesheet? PhilS wrote: Here is the formula that I have been using for over two years. =DATEDIF("12/31/2004",(TODAY()),"d") I was using this with XLS 2000 through Office 2K with WIN 2K. I saved my application on disk, reformatted the drive, installed XP Pro. Then reinstalled Office 2000. Then brought my application back from disk to the Spreadsheet folder that I use and in every instance where the formula is located I get the #NAME error. On the same machine I also have Office 2003. I get the same error in both of the versions of office. Thanks again for your help. PhilS "Dave Peterson" wrote: =datedif() in the worksheet datediff in VBA My bet it isn't your function (=datedif()), it's something else in the formula. You may want to post the whole formula if you can't isolate the problem. PhilS wrote: I have used the =DateDif function in the past. I recently had to format my drive and reinstalled Office 2k. When I returned my application, all the cells using the =DateDif function returned a #Name error. Hope someone can assist. Thank you in advance. Phil -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| datedif | Excel Discussion (Misc queries) | |||
| The 'DATEDIF' Function is not listed on my Excel program. | Excel Worksheet Functions | |||
| Does Excel 2000 have a 'datedif' function to calculate the number. | Excel Worksheet Functions | |||
Threaded Mode
