 |
 | 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 / General Excel Questions / March 2008Date formula
I need a formula that will determine if dates ( formatted xx/xx/xx)in column B & C are = or greater than 1 year apart and if so to return value "Yes", if not return value "No". Thank you! =IF(C1-B1>=365,"Yes","No" > I need a formula that will determine if dates ( formatted xx/xx/xx)in column > B & C are = or greater than 1 year apart and if so to return value "Yes", if > not return value "No". > > Thank you! What about Leap Years? Rick > =IF(C1-B1>=365,"Yes","No" > [quoted text clipped - 5 lines] >> >> Thank you! If B1 contains the starting date and C1 contains the ending date then : =IF(DATEDIF(B1,C1,"y")>=1,"Yes","No") Dates are simply numbers. Excel's date range is Jan. 1, 1900 is day 1 and Dec. 31, 9999 is day 2,958,465. If you format those numbers as dates you'll see dates, but they are just numbers. Formatting does not change cell values. The DATEDIF function takes leap years into account. The function is documented in many books on Excel and at http://www.cpearson.com/excel/datedif.aspx Tyro >I need a formula that will determine if dates ( formatted xx/xx/xx)in >column [quoted text clipped - 3 lines] > > Thank you! |
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.