Salam muje exel me age malum karne ka formula chahie plz agar kisi ko pata hai to jalde help kar de yah agar kisi ki age 1/3/1986 hai to wo 6/5/2009 tak us ki age kya ho gi plz help
Salam muje exel me age malum karne ka formula chahie plz agar kisi ko pata hai to jalde help kar de yah agar kisi ki age 1/3/1986 hai to wo 6/5/2009 tak us ki age kya ho gi plz help
In this example the formula in cell A3 is:
We need to convert this number of days into a number of years. Most years have 365 days but every fourth year has 366 days. So the average number of years is 365.25. Let's modify our formula...
=(A1-A2)/365.25
Now we can see a number of years, but it's still not quite right. We are getting an accurate result but we don't really want to see the fraction. As a last refinement we'll wrap the whole thing inside an INT() function to give us a whole number (an integer)
[CENTER][IMG]http://i39.tinypic.com/2vcz329.gif[/IMG][/CENTER]
Thanks
Bookmarks