Microsoft Excel formula question??

  • Thread starter Thread starter queenone4
  • Start date Start date
Q

queenone4

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
 
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.
 
Back
Top