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