Hi there people
i have prblem with date function in excel 2oo7. My question is, i have a sheet with lot of data and particulary i am looking at two columns (Status column & Date column). the status column will be having data values like "IC", "INS" , etc. next to it the date column will be there. problem is i change the status from "INS" to "IC" on february, 18,2011, in the date column i want today's date to be displayed automatically and should remain constant forever.
Status Date
INS
INS
INS
INS
INS
INS
Any help will be appreciated. Thanks in advance.
Regards
Adi
Bookmarks