| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Max date
This is what I have in range A2:G2
9-May 17-May 1-Jun 15-Jun 13-Jul 14-Jul 18-Jul 18 13-May 6-Jun 12-Jun 20-Jun 1-Jul 16-Jul 20-Jul 20 I want to see the max date monthwise and then find out the max of all the dates. Eg. In Row 1 max figure for May is 17, June 15, July 18 hence Answer = 18 In Row 1 max figure for May is 13, June 20, July 20 hence Answer = 20 Maxi |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| Recurring annual events using a specific date as a trigger date | Excel Worksheet Functions | |||
| extract date from the most current date | Excel Discussion (Misc queries) | |||
| Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Threaded Mode
