Excel help needed

[ITDWARRIOR]

dear friends main yeh chahta hon k agar main koi date excel k kisi cell main doon or us date ko agar sunday ho tu sunday print likha hua aey.

for examply

01/07/2012 ko sunday tha. main yeh chahta hon k jab bhi main koi esi date don jis main sunday ho tu sunday likha hua hai.


mere pass do columns hain


ek DATE ka doosra DAY ka... main date k column main koi bhi date don tu day k colum main automatic us date ka day ajae.



thanks

[syar]

assume A2 m aap date lekhte hain aur chahte hain k B2 m day aaje tu try

in B2

=LOOKUP(WEEKDAY(A2),{1,2,3,4,5,6,7},{"sun","mon","tues","wed","thur","fri","sat"})

regards,

[ITDWARRIOR]

thanks syar bhai for replying me.
syar bhai yeh tareqa tu thek hai magar is se her date ka day araha hai. main yeh chahta hon k jis date ko sunday ho sirf usi date k samny sunday likha hua aey. baqi ki dates per blank ho.
yeh jesy mainy nechy diya hai esa result ana chahiye.

(or ek or request ap se karonga k yeh same cheez maine kisi ki dekhi thi jo ke mod function se banai gai thi... kiya ap mujhe mod function thora clear karenge.. kiyun k mujhe sirf itna pata hai k mod function as a remider use hota hai).

Cell A Cell B
7/1/2012 SUNDAY
7/2/2012
7/3/2012
7/4/2012
7/5/2012
7/6/2012
7/7/2012
7/8/2012 SUNDAY
7/9/2012
7/10/2012
7/11/2012
7/12/2012
7/13/2012
7/14/2012
7/15/2012 SUNDAY
7/16/2012
7/17/2012
7/18/2012
7/19/2012
7/20/2012
7/21/2012
7/22/2012 SUNDAY
7/23/2012
7/24/2012
7/25/2012
7/26/2012
7/27/2012
7/28/2012
7/29/2012 SUNDAY
7/30/2012
7/31/2012

[syar]

replace formula with this one.

=if(weekday(a2)=1,"sunday","")

Mod function k tu bohat sare use hain. Ya case pa depend karta ha k aap kis kam k leye use karte hain. Agar aap forumla jo aap n dekha ha tu share karlain tu bahtar andaz m samajha sakon ga aur mujhy bhe kuch naya seekhne ko milay ga.

regrads

[ITDWARRIOR]

thanks syar bhai.

thek hai main ap ko woh formula jald he share karonga

[justali]

Mere dost Ap is se kuch madad le sakty hain..
is main ap kisi bhi tarhan ki sheet bunany main moth wise date use karty hon to is ko follow karain

date formula.xls

[*Xpert~Baba*]

thanks syar bhai.