Re: $$Excel-Macros$$ How to get the Month end date from a list of dates

2013-06-21 Thread respuzy
: Re: $$Excel-Macros$$ How to get the Month end date from a list of dates This message is eligible for Automatic Cleanup! (v...@vabs.in) Add cleanup rule: https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DMFjhRH3clvrszC7g5ImKzNnTSnORq1XXpzc%252F5TM%252B1OL1

Re: $$Excel-Macros$$ How to get the Month end date from a list of dates

2013-06-21 Thread respuzy
Subject: Re: $$Excel-Macros$$ How to get the Month end date from a list of dates This message is eligible for Automatic Cleanup! (d...@premor.net) Add cleanup rule: https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DQQfDjw1jYXl%252Fg9yrkNIgZGp

Re: $$Excel-Macros$$ How to get the Month end date from a list of dates

2013-06-21 Thread VBA VABZ
try edate formula.. Thanks On Sat, Jun 22, 2013 at 1:13 AM, Hilary Lomotey wrote: > Hello Experts, > > In the attached sheet, i have a list of dates in col A and index number in > Col B. What i am trying to achieve is that in Sheet two, i have written a > formula to give me index number as at