 |
 | 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 / Worksheet Functions / July 2006Dates
I have three cells on my worksheet that use dates. The dates that I use are the last day of the month. I want the first one to be inputed. The third one I want to be the same as the first, but the second to be the 15th of the month. date1 7/31/2006 date2 7/15/2006 date3 7/31/2006 How can I do this since some months have 30 and some have 31? Justlearnin: Assuming cell A1 is your input date, place this formula in cell A2. =DATE(YEAR(A1),MONTH(A1),15) Place this formula in cell A3. =DATE(YEAR(A1),MONTH(A1)+1,1)-1 Matt  SignatureFlintstone |
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.