date function
Thanks for your response
I have used DATE(YEAR(B8)-YEAR(B7),MONTH(B8-B7),DAY(B8-B7)) in three
adjacent column cells to get the result,
year, month, day separately (not together).I have to use the result year,
month day in a separate formula to
arrive at a solution.Hope I have cleared now..
|