You're welcome.
Regards - Dave.
> Date: Sat, 21 Aug 2010 15:22:42 -0700
> Subject: Re: $$Excel-Macros$$ Ageing of data
> From: tonycrazy...@gmail.com
> To: excel-macros@googlegroups.com
>
> Hi Dave,
>
> Thanks a lot for the quick response. Its working perf
gt;
> > Date: Fri, 20 Aug 2010 23:06:36 -0700
> > Subject: $$Excel-Macros$$ Ageing of data
> > From: tonycrazy...@gmail.com
> > To: excel-macros@googlegroups.com
>
> > Hi Experts,
>
> > Could anyone help me to have difference between two dates into
> >
rmulas in Columns C and D according to how
much data you have.
Regards - Dave.
> Date: Fri, 20 Aug 2010 23:06:36 -0700
> Subject: $$Excel-Macros$$ Ageing of data
> From: tonycrazy...@gmail.com
> To: excel-macros@googlegroups.com
>
> Hi Experts,
>
> Could anyone help me to
Hi Antony,
Assuming that the Header "Start date" is in Cell A1, please use the
following formula in the "Category" column:
=IF(AND(C2>=0,C2<=30),1,IF(AND(C2>=31,C2<=60),2,IF(AND(C2>=61,C2<=90),3,IF(AND(C2>=91,C2<=120),4,IF(C2>=120,5,"")
Please let me know if this helps or u need any further h
Hi Experts,
Could anyone help me to have difference between two dates into
different categories.
For eg:
Start date End dateDifference Category
6/6/20109/6/201092 4
Categories Values
0-301
31-60 2
61-90 3
91-120 4
>1205
Thanks in advance
