View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sarah (OGI) Sarah (OGI) is offline
external usenet poster
 
Posts: 128
Default Date calculation and possible vlookup

In cell C2 I have a date (in a dd/mm/yyyy format).

In cell H2 of the same worksheet, I would like to:
a) find out how many months difference there is between the date in C2 and
31 May 2007.
b) take the result of the above calculation and find that number in column A
of another worksheet and pull out the corresponding value in column B.

Any ideas?