| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Dates
If I enter a date in one cell (i.e. 7 March 2007 in cell A1), how do I get
another cell to automatically give me the last date of that month (i.e. 31 March 2007 in cell A2)? -- Erwin |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Excel Dates
Tue, 5 Jun 2007 21:51:00 -0700 from Erwin
: If I enter a date in one cell (i.e. 7 March 2007 in cell A1), how do I get another cell to automatically give me the last date of that month (i.e. 31 March 2007 in cell A2)? =EOMONTH(A1,0) Pretty cool, huh? -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Excel Dates
One way (without needing the Analysis Toolpak Add-in's EOMONTH):
=DATE(YEAR(A1),MONTH(A1)+1,0) Format as a Date. In article , Erwin wrote: If I enter a date in one cell (i.e. 7 March 2007 in cell A1), how do I get another cell to automatically give me the last date of that month (i.e. 31 March 2007 in cell A2)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Identifying unique dates in a range of cells containing dates... | Excel Discussion (Misc queries) | |||
| Identifying unique dates within a range of cells containing dates | Excel Discussion (Misc queries) | |||
| 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) | |||
| How do I get the dates on an excel chart to stay as dates instead. | Charts and Charting in Excel | |||
Linear Mode
