Ms-Office (Excel Sheet) Help Required

[fwdwaseem]

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

[syar]

Salam:

Can u explain a bit.

[fwdwaseem]

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

[fwdwaseem]

koi hi jo jawab dy saqy?

[GMD]

baat kuch samajh nahi ayi brother

[fwdwaseem]

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?

baat kuch samajh nahi ayi brother

[bais]

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

[syar]

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

=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.

[fwdwaseem]

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

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

=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.

[syar]

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

regards,

[fwdwaseem]

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

#NAME? wala error

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

=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.

[syar]

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,