| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Most current date
I am trying to summarize a bunch of entries with a pivot table but can't seem
to get the format that I am looking to attain. I have copied out all my item purchases, date and cost. I am trying to get the latest date and the amount that I purchased it for. If I create a pivot table I can only get it to return all the individual dates against an item. Is it possible to get the most current date only? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Most current date
Because the dates are just numbers, consider using the MAX() function.
-- Gary''s Student - gsnu200804 "Art" wrote: I am trying to summarize a bunch of entries with a pivot table but can't seem to get the format that I am looking to attain. I have copied out all my item purchases, date and cost. I am trying to get the latest date and the amount that I purchased it for. If I create a pivot table I can only get it to return all the individual dates against an item. Is it possible to get the most current date only? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Figuring Vacation Hrs. Earned using Current Date minus Hire Date | Excel Worksheet Functions | |||
| I want any date 90 days or older from current date change color | Excel Worksheet Functions | |||
| Make date change in excel to current date when opening daily? | Excel Discussion (Misc queries) | |||
| Can I automatically enter the current date or current time into a | New Users to Excel | |||
| Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
Linear Mode
