Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,501
Default Date calculation and possible vlookup

Hi,

Try this

=VLOOKUP(DATEDIF(C2,C3,"m"),Sheet2!A1:B16,2,FALSE)

I have put 31/5/2007 in C3 instead of in the formula and assumed C2 is
earlier than C3

Mike

"Sarah (OGI)" wrote:

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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sum/division calculation involving vlookup with array? markx Excel Worksheet Functions 2 March 30th 07 04:29 PM
Tricky Date calculation: How to calculate a future date [email protected] Excel Discussion (Misc queries) 9 August 11th 06 04:24 AM
Date calculation OCD Cindy Excel Worksheet Functions 3 April 5th 06 06:06 PM
vlookup and calculation questions dtmd Excel Worksheet Functions 2 November 19th 05 11:34 PM
Vlookup Calculation Issue cvolkert Excel Worksheet Functions 0 September 7th 05 02:28 AM


All times are GMT +1. The time now is 06:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"