G
Guest
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?
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?