excel edate #name error Clarkdale Georgia

Address 6170 King Arthur Dr, Douglasville, GA 30135
Phone (678) 401-3453
Website Link

excel edate #name error Clarkdale, Georgia

For example: =EDATE(B14,1) generates #NAME? Share Share this post on Digg Del.icio.us Technorati Twitter Rory Microsoft MVP - Excel ʅ_(ツ)_ʃ Add-in for posting ranges as copyable tables (bottom of the page) - Win & Mac Posting For example, the formula in D5 refers to the anchor date in A5 and the monthly interval of 18 in D1. View message headers Ads #2 May 2nd 06, 07:21 PM posted to microsoft.public.excel.misc Biff external usenet poster Posts: n/a Edate function Name error Hi!

Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries) Edate function Name error Author Name Remember Me? Comments Facebook Linkedin Twitter More Email Print Reddit Delicious Digg Pinterest Stumbleupon Google Plus About Susan Harkins Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Sep 1st, 2008,06:18 AM #5 Colin Legg MrExcel MVPLike totally RAD man Join Date Feb 2008 Location UK Posts share|improve this answer edited Jul 26 '14 at 11:08 answered Jul 24 '14 at 15:48 pnuts 33.8k63769 add a comment| Your Answer draft saved draft discarded Sign up or log

Do not use any error-handling functions such as IFERROR to mask the error. http://support.microsoft.com/kb/282847 Colin Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Sep 1st, 2008,06:23 AM #6 cornflakegirl Board Regular Join Date Nov 2004 Location UK Posts 2,021 Re: The time now is 03:40 AM. This used to work before, but now doesn't work on other > computers with Windows XP Pro and Excel 2000 either.

Privacy Policy | Cookies | Ad Choice | Terms of Use | Mobile User Agreement A ZDNet site | Visit other CBS Interactive sites: Select SiteCBS CaresCBS FilmsCBS RadioCBS.comCBS InteractiveCBSNews.comCBSSports.comChowhoundClickerCNETCollege NetworkGameSpotLast.fmMaxPrepsMetacritic.comMoneywatchmySimonRadio.comSearch.comShopper.comShowtimeTech share|improve this answer edited Jul 28 '14 at 14:05 answered Jul 24 '14 at 15:40 StephenH 742316 1 @pnuts, 1) His original function works on a string, I've tried it. To do that, go to the Formulas tab, in Defined Names group, click Use in Formula, and then select the defined name you want to add. Select Analysis ToolPak and click OK.

Related functions Excel EOMONTH Function Excel WORKDAY Function Excel Formula Training Bite-sized videos in plain English.┬áLearn nested IF, VLOOKUP, INDEX & MATCH, COUNTIFS, RANK, SUMIFS, SMALL, LARGE, and┬ámany formulas to handle See the following example of a SUM function referring to Profit, which is an undefined name in the workbook. What is your actual goal? –StephenH Jul 24 '14 at 15:31 add a comment| 2 Answers 2 active oldest votes up vote 8 down vote accepted DATEVALUE() is designed to make It works properly on one of her machines, but gives a #NAME error on the other, even though the Analysis Toolpak is ticked.

You may have to register before you can post: click the register link above to proceed. HTH Jason Atlanta, GA >-----Original Message----- >Hi All, > >I have a situation where I upgraded a computer from Win98 to WinXP and now >Excel 2000 files using EDATE for amortization Sign in Search Microsoft Search Products Templates Support Products Templates Support Support Apps Access Excel OneDrive OneNote Outlook PowerPoint SharePoint Skype for Business Word Install Subscription Training Admin How to correct Here is the FAQ for this forum. + Reply to Thread Results 1 to 3 of 3 #NAME?

Why is absolute zero unattainable? Disruptive posting: Flaming or offending other usersIllegal activities: Promote cracked software, or other illegal contentOffensive: Sexually explicit or offensive languageSpam: Advertisements or commercial links Submit report Cancel report Track this discussion John Zimmermann Register To Reply 03-25-2005,10:06 PM #2 Bernard Liengme Guest Re: #NAME? Syntax =EDATE (start_date, months) Arguments start_date - A date that represents the start date in a valid Excel serial number format.months - The number of months before or after start_date.

Powered by vBulletin Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc. Share it with others Twitter Linked In Google Reddit StumbleUpon Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not By using relative addresses for both arguments, you can quickly copy this formula to create the matrix. Share Share this post on Digg Del.icio.us Technorati Twitter Emma Your apparent nonchalance belies the fact that you can only think of me.

Exchange knowledge, and get help on all the latest office software and productivity tools--from various office suitesword processing to spreadsheets.Real-Time ActivityMy Tracked DiscussionsFAQsPoliciesModerators Question Problems with excel EDATE function in other See here for more information. I'm assuming you know about this, but since you didn't specify, it is a possible solution. more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed

The TEXT() function takes a value and a format string, so we format the cell value as Text as follows =TEXT(A2,"yyyy-mm-dd") And this gives us 2014-07-21 We then pass that result Browse other questions tagged excel date datetime or ask your own question. Any ideas on how to > solve this issue would be greatly appreciated. Click Add-ins.

Using INT() If we look at the numeric value of your Date in A2, we see that it is 41841.5309722222. Using LEFT() and DATEVALUE() Based on this Stackoverflow question that I found, it appears the issue could be a result of inconsistent formatting, so you might try this solution =DATEVALUE(LEFT(A2,FIND(" ",A2)-1)) current community chat Stack Overflow Meta Stack Overflow your communities Sign up or log in to customize your list. All rights reserved.

Edate function Name error « Previous Thread | Next Thread » Thread Tools Display Modes #1 May 2nd 06, 06:14 PM posted to microsoft.public.excel.misc SharonP. Is there an explanation for why this doesn't stick? Send No thanks Thank you for your feedback! × English (United States)‎ Contact Us Privacy & Cookies Terms of use & sale Trademarks Accessibility Legal © 2016 Microsoft {{offlineMessage}} Store Store Results Formatting I'm assuming you want just the date for calculation purposes, but if you just want to display the date, you can format the cell to only show the date

No fluff. Solution: Correct the typo in the syntax and retry the formula. the > problem is that this doesn't stick and I have to do it each time I open my > workbook that uses this formula. The DATE() function takes a Year, Month, and Day value, so by passing them into DATE() we can get the Date value from A2.

Is there a place in academia for someone who compulsively solves every problem on their own? In a comment I have just seen you mention "=INT(A2) return #VALUE!" so I would suggest selecting your date cells, DATA > Data Tools, - Text to Columns, Delimited, Delimiters Tab If they change regional settings on their pc's to UK settings, and force a re-calc, the errors clear.It appears EDATE doesn't like working other than in a UK environment.All pc's running If so, please check out the topics at Excel User Voice.

As you click each argument, Excel will give you the appropriate information for each one. First, copy the formula in B2 to C2:E2. Facebook Twitter Google+ YouTube LinkedIn Tumblr Pinterest Newsletters RSS If this is your first visit, be sure to check out the FAQ by clicking the link above. error as Excel cannot handle dates prior to 01/01/1900).#VALUE!-Occurs if either:The supplied start_date is not a valid dateorThe supplied months argument is non-numeric.

Will Monero CPU mining always be feasible? Reply With Quote Aug 26th, 2008,01:26 PM #2 Aladin Akyurek MrExcel MVP Join Date Feb 2002 Location The Hague, NL Posts 76,667 Re: Weird EOMONTH #NAME error Originally Posted by cornflakegirl Solution: Define a name in Name Manager, and then add the name to the formula.