Grouping period of date

  • Thread starter Thread starter Rechie
  • Start date Start date
R

Rechie

Hello,
I have data in following cells:
Column A -- Column B
Days Period
25 30
29 30
40 60
85 90

Column B should automatically read as 30 if no. of days in Column A are
1-30, and 60 if days are 31-60 and so on.

Thanks for your help.
Rechie
 
Hi Jacob,

The resuts should be as what I have input in column B. (i.e, if Column A is
25 days then results in Column B = 30 (belong to range 1-30)
1-30 days = 30
31-60 days = 60
61-90 days = 90
Thanks,

Rechie
 
Hi Rechie; try the below formula in cell B2 and copy down as required,,,

Col A Col B
Days Period
25 =CEILING(A2,30)
29 30
40 60
85 90

If this post helps click Yes
 
Hi Jacob,

It is working! But I forgot to mentioned that maximum period is 180 days
only, that means if data is more than 180 (say 460) it will still shows 180
in colum B.

Rechie
 
Back
Top