How do I create a formula that will enter a number in a total column when a
date is entered in a cell? Example:



CLC007 (2) CLC004 (3) TOTAL
2/28/2008 2/3/2008 2+3= 5

Do you mean that you want to add the days from the date? If so, try
this in C2:

=DAY(A2)+DAY(B2)

assuming your dates are in A1 and B1.

Hope this helps.

Pete

On Apr 11, 6:10*pm, queenone4
wrote:
How do I create a formula that will enter a number in a total column when a
date is entered in a cell? *Example:

CLC007 (2) * *CLC004 * *(3) * * * * * * * *TOTAL
2/28/2008 * * * * * 2/3/2008 * * * * * * * 2+3= * * * *5

if the data is exactly what mentioned here...enter the following in the cell
you need the total.

=IF(AND(A2<"",B2<""),SUM(MID(A1,9,1),MID(B1,9,1) ))

If both, A2 and B2 are not blank, this formula would add the 9th character
of A1 and 9th character of A2 which is 2 and 3.


"queenone4" wrote in message
...
How do I create a formula that will enter a number in a total column when
a
date is entered in a cell? Example:



CLC007 (2) CLC004 (3) TOTAL
2/28/2008 2/3/2008 2+3= 5