Convert dates

[amna77]

Hi, I don't know if its possible or not. I have dates in one column. Basically that sheet is about parts, like they suppose to check 3 parts per day. I have part number in one column and dates in other.
Ok If they have 4 same dates in that column, then it should increase the last date.
for example,

2 March
2 March
2 March
3 march
2 March
4 March
3 March


Now I have 2nd March 4 times, now I want to turn the last 2nd March date into 3 March. Same way its going to keep looking for dates. if any date will be 4 times in the column, then its going to convert the last date into next date.

Can any one help me with that.

Thanks in advance

 

[DonkeyOte]

On 2002-10-29 08:38, amna77 wrote:
Hi, I don't know if its possible or not. I have dates in one column. Basically that sheet is about parts, like they suppose to check 3 parts per day. I have part number in one column and dates in other.
Ok If they have 4 same dates in that column, then it should increase the last date.
for example,

2 March
2 March
2 March
3 march
2 March
4 March
3 March


Now I have 2nd March 4 times, now I want to turn the last 2nd March date into 3 March. Same way its going to keep looking for dates. if any date will be 4 times in the column, then its going to convert the last date into next date.

Can any one help me with that.

Thanks in advance

Say dates are in Column B and the first date you quote above is in B1 then formula in C1 would be:

=IF(COUNTIF($B$1:$B1,$B1)=4,$b1+1,$b1)

So in Col C you should find the correct dates have been added.


You HAVE to do this in a separate column for numerous reasons not least the fact that if you did this in B you would distort your results as the 4th 02/03 would become 03/03, meaning that what was originally the 4th 03/03 may now become the 5th 03/03 as the 4th 02/03 has now become the 4th 03/03 etc....



_________________
LASW10
This message was edited by lasw10 on 2002-10-31 05:51
This message was edited by lasw10 on 2002-10-31 05:51