Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi ,
Appreciate if somebody can help with a formula to retrieve, given a date, the equivalent one last year. An example: today is Dec 19 th, 2005 which is the third monday of this month, then my formula should give me: Dec 20 th, 2004 (the third monday of Dec. last year) I will use later this value in a vlookup construction to retrieve other info. In this case I donīt want to use vba. Rgds Mika |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
=month() function equivalent for fiscal calendar | Excel Worksheet Functions | |||
Excel 2003 month to month data change grid | Excel Discussion (Misc queries) | |||
copy worksheet from previous month and rename to current month | Excel Programming | |||
transfer cell $ amount to other sheet month-to-month without overc | Excel Discussion (Misc queries) | |||
Equivalent Of VAL | Excel Programming |