Page 1 of 2 12 LastLast
Results 1 to 12 of 16

Thread: Ms-Office (Excel Sheet) Help Required

  1. #1
    fwdwaseem's Avatar
    fwdwaseem is offline Senior Member+
    Last Online
    29th January 2021 @ 05:57 PM
    Join Date
    21 Dec 2010
    Location
    Rawalpindi
    Age
    36
    Gender
    Male
    Posts
    188
    Threads
    49
    Credits
    1,208
    Thanked
    7

    Default Ms-Office (Excel Sheet) Help Required



    kya excel sheet main koi aisa formula hi.. k aj maine 30 lekha to kal woh automatically 29 ho jaye?

  2. #2
    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

    Salam:

    Can u explain a bit.

  3. #3
    fwdwaseem's Avatar
    fwdwaseem is offline Senior Member+
    Last Online
    29th January 2021 @ 05:57 PM
    Join Date
    21 Dec 2010
    Location
    Rawalpindi
    Age
    36
    Gender
    Male
    Posts
    188
    Threads
    49
    Credits
    1,208
    Thanked
    7

    Default

    bahi seedhi c bat ki hi.. k agar main excel main 30 lekhta hon.. to kya yeh possible hi k woh automatically kal 29 ho jaye? matlab muje zarorat na parha osko 29 karna ki

  4. #4
    fwdwaseem's Avatar
    fwdwaseem is offline Senior Member+
    Last Online
    29th January 2021 @ 05:57 PM
    Join Date
    21 Dec 2010
    Location
    Rawalpindi
    Age
    36
    Gender
    Male
    Posts
    188
    Threads
    49
    Credits
    1,208
    Thanked
    7

    Default

    koi hi jo jawab dy saqy?

  5. #5
    GMD's Avatar
    GMD is offline Senior Member+
    Last Online
    13th September 2015 @ 02:33 PM
    Join Date
    05 Feb 2009
    Location
    Rahim Yar Khan
    Age
    43
    Gender
    Male
    Posts
    445
    Threads
    45
    Credits
    990
    Thanked
    14

    Default

    baat kuch samajh nahi ayi brother

  6. #6
    fwdwaseem's Avatar
    fwdwaseem is offline Senior Member+
    Last Online
    29th January 2021 @ 05:57 PM
    Join Date
    21 Dec 2010
    Location
    Rawalpindi
    Age
    36
    Gender
    Male
    Posts
    188
    Threads
    49
    Credits
    1,208
    Thanked
    7

    Default

    yar saf saf to keh raha hon k agar aj 4 march ko main excel main ik column main , main 30 lekhta hon, r 5 march ko automatically woh 29 ho jaye,
    r 6 march ko woh automatically 28 ho jaye..
    is tarha ka koi function mil jaye ya
    muje aisa mmil jaye k agar aj 4 march ko main '1' lekhta hon, to woh 5 march ko '2' automatically ho jaye ok?

    Quote GMD said: View Post
    baat kuch samajh nahi ayi brother

  7. #7
    bais is offline Senior Member
    Last Online
    31st July 2015 @ 02:07 PM
    Join Date
    23 Aug 2008
    Location
    Izlooo
    Gender
    Male
    Posts
    3,519
    Threads
    96
    Thanked
    263

    Default

    Quote fwdwaseem said: View Post


    kya excel sheet main koi aisa formula hi.. k aj maine 30 lekha to kal woh automatically 29 ho jaye?
    =======================
    solutions

    If u more clear your point what u wants then may it possible for its solutions at the earliest

  8. #8
    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

    you can achieve by two methods
    1. by Event Macro
    2. By Formula.

    BUt the easiest way to achieve this by formula. I assume aap excel 2007/2010.Follow this procedure.

    1.Formula ka tabe m Define Name par click karain.
    2. Name k box m apne marze ka name lekhain for example "c_date"
    3. aur refer to k box m apni date lekhain jese ap na kaha 4th march. Date must be in dd/mm/yyyy format. e.g =3/4/2012
    4. Ok click Karain.

    Then again formula k tab m define name m ja kar Define name par click karain.
    1. Refer k name m apni marze ka name d e.g. elapseday
    2. refer to k box m
    Code:
    =today()-c_day
    enter kar ka enter kar dain.


    Ab aap jahan par apna number lekhtain hain for example a1 m agar ap 30 lekhtain tu is k jagha ye formula lekhain.

    a1 m enter karain.
    =30-elapseday
    aur enter karain.

    Note: Name aap apne marze k define kar sakte hain.

    is ka dosra method event procedure hain. Agar ap ko macro programing ki know how ha tu you can do otherwise it will difficult.

    regards.

  9. #9
    fwdwaseem's Avatar
    fwdwaseem is offline Senior Member+
    Last Online
    29th January 2021 @ 05:57 PM
    Join Date
    21 Dec 2010
    Location
    Rawalpindi
    Age
    36
    Gender
    Male
    Posts
    188
    Threads
    49
    Credits
    1,208
    Thanked
    7

    Default

    ms-office 2003 main yeh formula tab kaha hoga??
    main ms-office 2003 use kar raha hon

    Quote syar said: View Post
    you can achieve by two methods
    1. by Event Macro
    2. By Formula.

    BUt the easiest way to achieve this by formula. I assume aap excel 2007/2010.Follow this procedure.

    1.Formula ka tabe m Define Name par click karain.
    2. Name k box m apne marze ka name lekhain for example "c_date"
    3. aur refer to k box m apni date lekhain jese ap na kaha 4th march. Date must be in dd/mm/yyyy format. e.g =3/4/2012
    4. Ok click Karain.

    Then again formula k tab m define name m ja kar Define name par click karain.
    1. Refer k name m apni marze ka name d e.g. elapseday
    2. refer to k box m
    Code:
    =today()-c_day
    enter kar ka enter kar dain.


    Ab aap jahan par apna number lekhtain hain for example a1 m agar ap 30 lekhtain tu is k jagha ye formula lekhain.

    a1 m enter karain.
    =30-elapseday
    aur enter karain.

    Note: Name aap apne marze k define kar sakte hain.

    is ka dosra method event procedure hain. Agar ap ko macro programing ki know how ha tu you can do otherwise it will difficult.

    regards.

  10. #10
    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

    Office 2003 m Insert k Menu m Name Manager k function hot e hain.

    regards,

  11. #11
    fwdwaseem's Avatar
    fwdwaseem is offline Senior Member+
    Last Online
    29th January 2021 @ 05:57 PM
    Join Date
    21 Dec 2010
    Location
    Rawalpindi
    Age
    36
    Gender
    Male
    Posts
    188
    Threads
    49
    Credits
    1,208
    Thanked
    7

    Default

    brother ap na jo tareeka batya hi... os procedure k through ho nhe raha...
    error hi..
    formula not recognized?

    #NAME? wala error


    Quote syar said: View Post
    you can achieve by two methods
    1. by Event Macro
    2. By Formula.

    BUt the easiest way to achieve this by formula. I assume aap excel 2007/2010.Follow this procedure.

    1.Formula ka tabe m Define Name par click karain.
    2. Name k box m apne marze ka name lekhain for example "c_date"
    3. aur refer to k box m apni date lekhain jese ap na kaha 4th march. Date must be in dd/mm/yyyy format. e.g =3/4/2012
    4. Ok click Karain.

    Then again formula k tab m define name m ja kar Define name par click karain.
    1. Refer k name m apni marze ka name d e.g. elapseday
    2. refer to k box m
    Code:
    =today()-c_day
    enter kar ka enter kar dain.


    Ab aap jahan par apna number lekhtain hain for example a1 m agar ap 30 lekhtain tu is k jagha ye formula lekhain.

    a1 m enter karain.
    =30-elapseday
    aur enter karain.

    Note: Name aap apne marze k define kar sakte hain.

    is ka dosra method event procedure hain. Agar ap ko macro programing ki know how ha tu you can do otherwise it will difficult.

    regards.

  12. #12
    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

    Brother ap ne jo error bataya ha ye is waqt ata ha jab ap name manager m name wrong define karte hain. Agar ho sake tu ap apne file attached kar dain. aur attached file ko bhe check kar lain.

    regards,
    Attached Files Attached Files

Page 1 of 2 12 LastLast

Similar Threads

  1. Microsoft Office 2010
    By Max_ in forum English IT Zone
    Replies: 32
    Last Post: 30th September 2015, 12:44 PM
  2. remove office non genuine error
    By mirza matloob in forum General Discussion
    Replies: 2
    Last Post: 6th August 2011, 03:41 PM
  3. Replies: 1
    Last Post: 27th January 2010, 10:03 PM
  4. MS Office 2000 Shortcut Keys
    By general in forum General Discussion
    Replies: 4
    Last Post: 31st May 2007, 04:07 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
  •