krishhi
03-09-2010, 09:18 PM
Hi,
I have some issue. I want to find out the difference between two dates(Here i need Months).
1. The first date is vary from cell to cell.
2. The Second date is Constant.
I need to find out the difference between these two. and i have some condition if the date below the 1 - 15days, it should concern the whole month. or else it should concern the count the next month.
If i have two dates, let say : 03/09/2008 (mm/dd/yyyy) and constant date is : 12/12/2009
Here the difference of the months is: 10 (because the date is below 15)
and check another example :
05/16/2008 (mm/dd/yyyy) and constant date is : 12/12/2009
here the difference of the months is :19 (because the date is above 15)
Thanks
Krish
I have some issue. I want to find out the difference between two dates(Here i need Months).
1. The first date is vary from cell to cell.
2. The Second date is Constant.
I need to find out the difference between these two. and i have some condition if the date below the 1 - 15days, it should concern the whole month. or else it should concern the count the next month.
If i have two dates, let say : 03/09/2008 (mm/dd/yyyy) and constant date is : 12/12/2009
Here the difference of the months is: 10 (because the date is below 15)
and check another example :
05/16/2008 (mm/dd/yyyy) and constant date is : 12/12/2009
here the difference of the months is :19 (because the date is above 15)
Thanks
Krish