Results 1 to 6 of 6

Thread: In MS-Excel "Due Date" column formula

  1. #1
    a_shaheer's Avatar
    a_shaheer is offline Advance Member
    Last Online
    20th November 2021 @ 02:49 PM
    Join Date
    30 Nov 2010
    Location
    Karachi
    Gender
    Male
    Posts
    1,063
    Threads
    128
    Credits
    222
    Thanked
    47

    Default In MS-Excel "Due Date" column formula



    Mein Xcel me apny ghar k bills specially apni kids k fees wagera or esy bills/dues jo every month ek particular date tak pay krny hoty hain unka record manage krna chahata hoon. mujhy jo help chahiye wo ye k mein ek Due Date ka column banana chahata hon or chahata hoon k jb ek month ki due date (jo k constant hoti hy) tk payment show hojae tu next month ki due date mentioned hojaye yani yani Date+next month name:

    for example:
    ek child ki fee every month ki 10th tak pay krni hoti hy tu on January "Due Date" mention horaha hoo "10 January" or fee payment k baad or 10 january guzarny k baad next month ki date show hojaye e.g. "10 February" or isi terha her month due date guzarny k bad next date+month k sath show hojay.

    is ko koi excel sheet per bana kr mujhy share krdy tu meharbani hogi
    http://www.itdunya.com/signaturepics/sigpic171665_1.gif

  2. #2
    a_shaheer's Avatar
    a_shaheer is offline Advance Member
    Last Online
    20th November 2021 @ 02:49 PM
    Join Date
    30 Nov 2010
    Location
    Karachi
    Gender
    Male
    Posts
    1,063
    Threads
    128
    Credits
    222
    Thanked
    47

    Default

    Sample file attached, pleaze review!
    Attached Files Attached Files

  3. #3
    a_shaheer's Avatar
    a_shaheer is offline Advance Member
    Last Online
    20th November 2021 @ 02:49 PM
    Join Date
    30 Nov 2010
    Location
    Karachi
    Gender
    Male
    Posts
    1,063
    Threads
    128
    Credits
    222
    Thanked
    47

    Default

    Pease Close the thread, kia faida jb koi xpert 8-9 days guzarny k baad bhi response na day!

  4. #4
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    Quote a_shaheer said: View Post
    Sample file attached, pleaze review!
    See if this could help you. Aap is ko test kr k btayae ga k drust kam kr raha ha k nahee. sheet m aik jaghe yellow highlight ha aap n us ko delete nahee krna. ya tu use hide kr dain ya kisi aur jagha sheet p copy kr dain. Aap ko jab bhe month change ho ga sirf kisi bhe aik cell m F2 daba k enter press krna ho ga. wese iske zarorat tu nahee ho gi. lkn phr bhe ahtyatan aap kr leya kejeya ga. Formula

    koi masla ho ya aap smajhte hon k mazeed kam ki zarorat ho tu btaya ga. Aap ki problem k leye MACRO drust solution ha agr mujy time mila tu phr kabhe share kar longa aap sa. mere apni kuch masrofiat hain jis ki wajha sa forum p ana kam hota ha. but if you need it urgent then i can send you my email.

    regards,
    Attached Files Attached Files

  5. #5
    a_shaheer's Avatar
    a_shaheer is offline Advance Member
    Last Online
    20th November 2021 @ 02:49 PM
    Join Date
    30 Nov 2010
    Location
    Karachi
    Gender
    Male
    Posts
    1,063
    Threads
    128
    Credits
    222
    Thanked
    47

    Default

    Quote syar said: View Post
    See if this could help you. Aap is ko test kr k btayae ga k drust kam kr raha ha k nahee. sheet m aik jaghe yellow highlight ha aap n us ko delete nahee krna. ya tu use hide kr dain ya kisi aur jagha sheet p copy kr dain. Aap ko jab bhe month change ho ga sirf kisi bhe aik cell m F2 daba k enter press krna ho ga. wese iske zarorat tu nahee ho gi. lkn phr bhe ahtyatan aap kr leya kejeya ga. Formula

    koi masla ho ya aap smajhte hon k mazeed kam ki zarorat ho tu btaya ga. Aap ki problem k leye MACRO drust solution ha agr mujy time mila tu phr kabhe share kar longa aap sa. mere apni kuch masrofiat hain jis ki wajha sa forum p ana kam hota ha. but if you need it urgent then i can send you my email.

    regards,
    Shukria Syar bhai, at least apka reply tu aya wo bhi solution k saath wrana tu me disappointed hogaya tha. bohat shukria itni koi urgency nhi hy me check kr k apko response deta hoon. again

  6. #6
    a_shaheer's Avatar
    a_shaheer is offline Advance Member
    Last Online
    20th November 2021 @ 02:49 PM
    Join Date
    30 Nov 2010
    Location
    Karachi
    Gender
    Male
    Posts
    1,063
    Threads
    128
    Credits
    222
    Thanked
    47

    Default

    Syar bhai, apny jo formula bana kr dia hy wo filhal sahi kam kr raha hy or umeed hy k ainda bhi sahi result dega or mera masla bhi solve hogaya hy, lakin aap mujhy macro zaro bana kr dena jb bhi time milay or phir mujh PM krdena. I m really thankful to u Allah ki rahmatain hoon ap per or IT Dunya ki pori team per.

Similar Threads

  1. Excel tip (Hidde formula in formula bar in excel)
    By Honour12 in forum Urdu Tutorials & Designing
    Replies: 14
    Last Post: 31st May 2016, 10:06 AM
  2. How to remove Formula Link in Excel.
    By Rahmatullah Ktk in forum Ask an Expert
    Replies: 1
    Last Post: 4th April 2016, 12:28 PM
  3. Want excel formula for this .... problem
    By Nadeem Ahmed Kh in forum Ask an Expert
    Replies: 5
    Last Post: 23rd July 2012, 02:25 PM
  4. Solved Required Excel Formula
    By Qutab in forum Solved Problems (IT)
    Replies: 13
    Last Post: 31st January 2012, 07:52 PM
  5. Solved Excel formula
    By masadijaz in forum Solved Problems (IT)
    Replies: 8
    Last Post: 15th July 2011, 10:39 AM

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
  •