On Apr 11, 9:04 am, 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,

Inside of Excel go to Insert/Function and change the "Or select a
category:" option to "Date & Time." Excel already has the functions
you need for this. You can also use the CONCATENATE funtion to
"smash" things together. (The "&" will do the same thing CONCATENATE
does).

Here is an example: =A1&"/"&DAY(A3)&"/"&A2

Matt