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