View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mika Mika is offline
external usenet poster
 
Posts: 48
Default equivalent nīth day in a month

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