Thanks Bijorn for ur help,
one more querry that instead of runing macro more often on this file, if u can suggest such thing that when i open the particular file the cell which had returned the date in d column (whatever may be the date) then it should not update the date to today's date. (let say i have mention yes in some cell e.g 10 cells (today), then those 10 cell's d column should show today's date. if I open this file next day then while calculating the formula when u open the file it should ignore those cell in d column which had already mentioned the date)
Thnks Again.....

HI,
creating such a macro would be quite tricky, and on the top of that, you might be needed to adjust the macro yourself if your cells are moved or extended in any way. It is also a solution which might be a little unsure, since any type of mistake/error/systemproblems etc, might cause the date to change to todays date by "accident".

I am not sure what you want to achieve by your new question. I find it even easier to press "CTRL+Y" in a cell to get the complete job done (including the date), instead of typing "Yes" followed by an enter (and in addition have a really complex macro to maintain/write).

I suggest that you stay with the short and easy macro

Kind regards
Bjorn