| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
=DATE(YEAR(A2),(INT((MONTH(A2)-1)/3)+1)*3+1,0)
-- HTH RP (remove nothere from the email address if mailing direct) "SDolley" wrote in message ... The EOMonth function is great. But what about creating a similar function for determining the end of the current quarter that a specified date is in? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return value with using Excel function | New Users to Excel | |||
| The description of the ATAN2 function in Microsoft Excel is not 1. | Excel Worksheet Functions | |||
| Access Module coded converted to Excel Function | Excel Discussion (Misc queries) | |||
| Does Excel 2000 have a 'datedif' function to calculate the number. | Excel Worksheet Functions | |||
| Missing function in Excel 2003 | Excel Discussion (Misc queries) | |||
Threaded Mode
