| 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? |
| 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) | |||
Threaded Mode
