dates

[Genny]

Assume the following: Cell A1 contains a month - 04; cell A2 contains a year - 2007, cell A3 contains a date - 04/09/1973, and cell A4 also contains a date - 08/09/2007. How do I make a date from the month in cell A1, the day in cell A3, and the year in cell A2 so that the end result is 04/09/2007? I need this so that I can then calculate the number of days between this date and the date in cell A4.

[starguy]

Assume the following: Cell A1 contains a month - 04; cell A2 contains a year - 2007, cell A3 contains a date - 04/09/1973, and cell A4 also contains a date - 08/09/2007. How do I make a date from the month in cell A1, the day in cell A3, and the year in cell A2 so that the end result is 04/09/2007? I need this so that I can then calculate the number of days between this date and the date in cell A4.

try this

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

[BigBas]

Try this formula and let me know if it works:

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

EDIT: Starguy beat me to it

[Genny]

I tried it and it works beautifully!! Thank you both very much!!!!

[starguy]

I tried it and it works beautifully!! Thank you both very much!!!!

you're welcome here and thank you for the feedback.