Results 1 to 4 of 4

Thread: Excel Problem Its urgents

  1. #1
    toberia's Avatar
    toberia is offline Senior Member+
    Last Online
    18th February 2014 @ 08:22 PM
    Join Date
    05 Dec 2008
    Age
    35
    Posts
    268
    Threads
    148
    Credits
    0
    Thanked
    3

    Default Excel Problem Its urgents

    Dear all,

    Umeed hai app sab theek honge, Dostoo app sab ke liye ek new problem le kar aya ho. Shayad kuch seekhne ko mil jaye. Excel me ek formula chahta ho k 15-jan-2010 se 30-jan-2010 tak kitne din aate hai 15 din yeh me formule me chahta hia.
    Example

    A B C
    Open day close day remain days
    15-01-2010 31-01-2010 16 days


    Kindly jo 16 me ne manual likha hai me us ko formula me chahta ho. So please help me its urgents.

    Regards
    It member

  2. #2
    denzees is offline Senior Member+
    Last Online
    21st June 2018 @ 01:58 AM
    Join Date
    07 Feb 2009
    Location
    Lahore
    Gender
    Male
    Posts
    58
    Threads
    12
    Credits
    1,030
    Thanked
    6

    Default Date Calculation Formula

    Asalam-o-Alaekum

    Dear Brother suppose that your first date is written in Column A1 and Second Date in written in Column A2.
    Now in any other column write or copy this formula..

    YEAR(A2)-YEAR(A1)-IF(OR(MONTH(A2)<MONTH(A1),AND(MONTH(A2)=MONTH(A1),
    DAY(A2)<DAY(A1))),1,0)&" years, "&MONTH(A2)-MONTH(A1)+IF(AND(MONTH(A2)
    <=MONTH(A1),DAY(A2)<DAY(A1)),11,IF(AND(MONTH(A2)<M ONTH(A1),DAY(A2)
    >=DAY(A1)),12,IF(AND(MONTH(A2)>MONTH(A1),DAY(A2)<D AY(A1)),-1)))&" months,
    "&A2-DATE(YEAR(A2),MONTH(A2)-IF(DAY(A2)<DAY(A1),1,0),DAY(A1))&" days"


    It will return you exact number of Year, Months and Days remaining.

    To get Only number of Days remaining ,use this formula.
    =A2-DATE(YEAR(A2),MONTH(A2)-IF(DAY(A2)<DAY(A1),1,0),DAY(A1))&"days"

    To get Only Months remaining, Use this formula.
    =MONTH(A2)- MONTH(A1)+IF(AND(MONTH(A2) <=MONTH(A1), DAY(A2)<DAY(A1)),11,IF(AND(MONTH(A2)<MONTH(A1),DAY (A2)>=DAY(A1)),12,IF(AND(MONTH(A2)>MONTH(A1),DAY(A 2)<DAY(A1)),-1)))&" months"

    and finally to get Only Years, use this formula,
    =YEAR(A2)-YEAR(A1)-IF(OR(MONTH(A2)<MONTH(A1),AND(MONTH(A2)=MONTH(A1), DAY(A2)<DAY(A1))),1,0)&" years"


    Hope you will find it helpful.

    Regards
    Salman Amin.

  3. #3
    toberia's Avatar
    toberia is offline Senior Member+
    Last Online
    18th February 2014 @ 08:22 PM
    Join Date
    05 Dec 2008
    Age
    35
    Posts
    268
    Threads
    148
    Credits
    0
    Thanked
    3

    Default

    its not work clearly please check attachement and recheck this formula


    Attached Images Attached Images  

  4. #4
    sayhellotoit's Avatar
    sayhellotoit is offline Senior Member
    Last Online
    23rd September 2017 @ 07:51 PM
    Join Date
    01 May 2009
    Posts
    1,003
    Threads
    5
    Credits
    53
    Thanked
    127

    Default

    Formula tu wohi hay jo 2 numbers ko minus kernay ka hay.
    matlab column C mein =B2-A2 likhain aur aik aur cheez column C pay right-click karain aur Format Cell pay click karain aur Category General select karain.

    Sample File yahan say download karain:
    http://www.mediafire.com/download.php?z033doco4od

Similar Threads

  1. Solved excel problem plz help
    By nissa in forum Solved Problems (IT)
    Replies: 7
    Last Post: 12th May 2015, 12:54 PM
  2. Excel Problem
    By Qutab in forum Ask an Expert
    Replies: 2
    Last Post: 14th December 2013, 10:20 AM
  3. laptop latitude D600 drivers plz urgents
    By love_u_it_dunya in forum Ask an Expert
    Replies: 4
    Last Post: 28th December 2009, 03:03 PM
  4. Excel Problem
    By shahleopak in forum Ask an Expert
    Replies: 24
    Last Post: 5th August 2009, 09:11 AM
  5. Excel problem
    By shahleopak in forum Ask an Expert
    Replies: 12
    Last Post: 23rd July 2009, 02:14 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
  •