Grouping period of 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
 
R

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
 
J

Jacob Skaria

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
 
R

Rechie

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nested Greater than or less than Formula 4
Formula not reading date format 3
Make a mekko chart in Excel 2007 in three easy Steps 1
Getting a value out of a Matrix 4
Month days over a time period 5
Conditional Format where ANY date is >= 30, 60, 90 days EXCEL 2007 1
Average of Days Between Customers Visits 0
return value 2

Top