 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / August 2006Edate problems
I am having problems wtih getting the correct date. My start date is 03/12/06 in cell C4 and I want to calculate 6 calendar months from that date into another cell. All I end up with is 09/12/06, when it should be done in regular calendar months. The answer should be 09/21/06 but I don't know how to get the formula to get that date. I tried using just the date function and then tried edate function. Please help By what criteria should 6 months on from 12 Mar 2006 be 21 Sep 2006?  SignatureHTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) > I am having problems wtih getting the correct date. My start date is 03/12/06 > in cell C4 and I want to calculate 6 calendar months from that date into > another cell. All I end up with is 09/12/06, when it should be done in > regular calendar months. The answer should be 09/21/06 but I don't know how > to get the formula to get that date. I tried using just the date function and > then tried edate function. Please help One way: =DATE(YEAR(C4),MONTH(C4)+6,DAY(C4)) > I am having problems wtih getting the correct date. My start date is 03/12/06 > in cell C4 and I want to calculate 6 calendar months from that date into > another cell. All I end up with is 09/12/06, when it should be done in > regular calendar months. The answer should be 09/21/06 but I don't know how > to get the formula to get that date. I tried using just the date function and > then tried edate function. Please help playing devils advoate here....what say the start date is after 21 of the month? Signaturepaul paul.shepherd@nospamparadise.net.nz remove nospam for email addy! > One way: > [quoted text clipped - 6 lines] > > to get the formula to get that date. I tried using just the date function and > > then tried edate function. Please help Do you want to add 180 days rather than 6 months? =DATE(YEAR(C4),MONTH(C4),DAY(C4)+180). Excel is like a child; it does EXACTLY what you tell it and nothing more. Your challenge is figuring out what to tell it to do. HTH Lou > playing devils advoate here....what say the start date is after 21 of the > month? [quoted text clipped - 9 lines] > > > to get the formula to get that date. I tried using just the date function and > > > then tried edate function. Please help |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.