That should be right, as excel usually formats a cell to Date, when you enter
a date it recognizes as a date. You could check by right clicking the cell
with the date, select "format" and see if "Date" is the highlighted format.
If it is not, you need to format them by selecting the range of cells that
will have the expiry date, right click and format as "date".
If they already are then the issue is somewhere else. My formula also
assumed that the expiry date would be in cell B1. (I'm not sure how
experienced you are so I'm slightly unsure at which level I should be
communicating - I'm assuming you're somewhat inexperienced?)
What would really help is for you to describe the error. Does the cell
return an error? (like: "#N/A"), or is it a different kind of error? The more
info you can give me the better.
Or, as a test try this:
In cell B1, enter 4/15/2008. In cell B2, enter 6/15/2008. In cell C1, enter
the formula I gave you. Drag that formula downt to C2. (do this by selecting
the little black box in the bottom right of the cells selection highlight,
and drag it down to the row below. This will copy the formula and adjust the
references to B column appropriately)
Let me know what happens . .
"Bob P" wrote:
> Think it may have been because I used todays date in this format 4/11/2008.
> is that the correct format for date??
> "mike" wrote:
>
> > Bob,
> > It works for me. Is you're date formated as Date? or is it just text?
> >
> > Can you describe the error a bit more?
> >
> > Mike
> >
> >
> > "Bob P" wrote:
> >
> > > Mike thanks for you quick response however when I type that formula in the c
> > > column I get a message that says there is an error. And Ideas what is wrong
> > >
> > > "mike" wrote:
> > >
> > > > Assuming the items are in column A and the expiry date is in column B, and
> > > > the alert will be outputted to column C, put this formula in column C.
> > > >
> > > > =IF(B1-TODAY()<30,"ALERT","")
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > "Bob P" wrote:
> > > >
> > > > > I want to create a file that has the name of items and their expiration date
> > > > > but would like to set so I get an alert a month before the item expires. Is
> > > > > that possible with excel? If so where can I find information in how to
> > > > > configure the file to do this??
|
Similar Threads
