excel date problem
actually what i need is,in one excel cell i will be entering 15/8/05 and the
next cell i want to get the value as 30/8/06 ,that means next year same month with end of month date |
Hi!
A1 = 8/15/2005 B1 = formula: =DATE(YEAR(A1)+1,MONTH(A1)+1,0) August has 31 days! Biff "Saiju Mammen" <Saiju wrote in message ... actually what i need is,in one excel cell i will be entering 15/8/05 and the next cell i want to get the value as 30/8/06 ,that means next year same month with end of month date |
Either that or:
=EOMonth( A1, 12) For this you need to have the Analysis Tool Pack add-in activated. Chris |
All times are GMT +1. The time now is 11:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com