Help with dates

[Guest]

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,

 

[matt]

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

 

[Guest]

In a cell put in the formula
=Date(A2,A1,day(A3))
format the cell mm/dd/yyyy

to get the difference

=Date(A2,A1,day(A3))-A4

format the cell to show the difference as General

 

[Guest]

To get the date...

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

To get the difference

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

 

[matt]

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

One more note, dates are serial numbers (e.g. 8/9/2007 is 39,303), so
the dates can be subtracted from each other to arrive at the total
number of days.

Matt

 

[Guest]

Reverse the formula for the difference - I see the A4 date is later.