| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dates
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dates
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 -- Flintstone ------------------------------------------------------------------------ Flintstone's Profile: http://www.excelforum.com/member.php...o&userid=15310 View this thread: http://www.excelforum.com/showthread...hreadid=565804 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dates showing are not what I type | New Users to Excel | |||
| Dates and Intervals | Excel Worksheet Functions | |||
| formula to add dates. | Excel Worksheet Functions | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
Linear Mode
