excel spreadsheet

[Mike]

My question is how do I take the date from each cell in
the column and flag it out of date in another column

ie the chemical has an expiration of 10/28/03, if today is
10/30/03, how do i get a message to show up in another
column using excel?

 

[Kim]

Might want to try an Excel newsgroup. Here's a link for
you.

http://communities.microsoft.com/newsgroups/default.asp?
icp=Prod_Office&sLCID=US&newsgroup=microsoft.public.excel.m
isc

 

[Bruce Kenney]

HI Mike,

assume column B has dates, past and present.
column C, has a formula checking for "Expirations".

Ex.
column B Column C
row 2 9/28/2003 =IF(TODAY()>$B2,"Expired","OK)
row 3 9/29/2003 =IF(TODAY()>$B3,"Expired","OK)
row 4 12/12/2003 =IF(TODAY()>$B4,"Expired","OK)

Column C will have the results:
Expired
Expired
OK

Good Luck
Bruce Kenney
(e-mail address removed)

 

[Bob I]

Try something like
=IF(TODAY>D1,"FLAG","")
Cell D1 containing the expiration date