Formula Question

  • Thread starter Thread starter Victoria
  • Start date Start date
V

Victoria

I have done some research and I haven't been able to find
the answer.

In cell A3 I have a date (e.g. 8/25/03) and in cell B3 I
have a number that represents number of years (e.g. 36
for three years, 24 for two years, etc.). In cell C3 I
would like to have A3 times B3. If it was 8/25/03 * 36,
C3 would show 8/25/06. Is this possible?

Hopefully, I explained this well enough.

Thank you in advance for your help!
 
Victoria,

With the date in A1 and the # of months in B1

=EDATE(A1,B1)

will return the result you are looking for. It requires the analysis
toolpack.

PC
 
Back
Top