Results 1 to 3 of 3

Thread: plz exel help

  1. #1
    faheemgul's Avatar
    faheemgul is offline Senior Member+
    Last Online
    2nd October 2022 @ 10:24 PM
    Join Date
    30 Jul 2008
    Age
    38
    Posts
    447
    Threads
    99
    Credits
    4
    Thanked: 1

    Default plz exel 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

  2. #2
    Sinbad's Avatar
    Sinbad is offline Senior Member
    Last Online
    3rd April 2018 @ 10:55 PM
    Join Date
    04 Jan 2008
    Posts
    2,452
    Threads
    178
    Credits
    59
    Thanked
    7

    Default

    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]

  3. #3
    Join Date
    25 Apr 2006
    Location
    مکہ مکرمہ
    Gender
    Male
    Posts
    188
    Threads
    13
    Credits
    0
    Thanked
    3

    Default

    Thanks

Similar Threads

  1. Need exel in pdf
    By Samar_alee in forum Ask an Expert
    Replies: 4
    Last Post: 30th December 2012, 04:29 PM
  2. ms exel
    By engr usman in forum Ask an Expert
    Replies: 2
    Last Post: 25th February 2012, 08:38 PM
  3. Plz help me on exel plz
    By keyboard in forum Ask an Expert
    Replies: 7
    Last Post: 10th July 2011, 07:23 AM
  4. exel help
    By rajawaseem in forum Introduction
    Replies: 8
    Last Post: 25th February 2010, 05:35 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •