| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find row of date of previous year
Thanks Tom,
Neat and instructive. Michael "Tom Ogilvy" wrote: Sure. My formula assumed they were sorted ascending. A slight adjustment and it returns 4 for your test data: =MATCH(DATE(YEAR(TODAY())-1,12,31),A1:A17,-1)+ISERROR(MATCH(DATE(YEAR(TODAY( ))-1,12,31),A1:A17,0))*1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keep a previous year when entering down a column | Excel Discussion (Misc queries) | |||
| How to find the year from a given date | Excel Discussion (Misc queries) | |||
| Calulate Sales for Previous Year | Excel Worksheet Functions | |||
| Use year and weeknr to find date?? | Excel Discussion (Misc queries) | |||
| Previous year data into chart | Excel Discussion (Misc queries) | |||
Threaded Mode
