To get the date...

=DATE(A2,A1,DAY(A3))

To get the difference

=A4-DATE(A2,A1,DAY(A3))
--
HTH...

Jim Thomlinson


"Genny Santos" wrote:

I'm using Excel 2003. I'm ok with basic formulas but don't do anything with
macros. I need help with dates. Assume that cell A1 contains a month - 04,
cell A2 contains a year - 2007, cell A3 contains a date - 04/09/1973, and
cell A4 contains a date - 08/09/2007. How can I create a date using the
month from cell A1, the day from cell A3, and the year from cell A2 so that
the date is displayed as 04/09/2007. I need to be able to calculated the
number of days between this date and the date in cell A4.

Thanks,