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
Hi Dave,
Thanks a lot for the quick response. Its working perfectly.Thanks
once again.
Regards,
Tony
On Aug 21, 11:45 am, Dave Bonallack wrote:
> Hi Antony,
>
> See if the attached contains what you need.
>
> For the catagory column, I've used a nested IF formula. But you could also
> hav
Hi Antony,
See if the attached contains what you need.
For the catagory column, I've used a nested IF formula. But you could also have
a separate table and use VLOOKUP.
Columns A & B are formatted as Date, while Column C is formatted as Number.
You will have to fill-down the formulas in Colum
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
