# formulation of an expiry summary

1. ## formulation of an expiry summary

I am trying to create a summary sheet in my workbook which will show the earliest expiry dates for a particular item. The dates are entered into other worksheets in the workbook and are linked to the summary worksheet, however the problem that I am finding is that if no data (date) is entered into a cell under a particular heading on one of the other worksheets, it is coming up on the summary sheet as Jan-00. How do I get rid of this ?

The next problem is that I need a formula that will recognise the earliest expiry date. I have tried the =MIN but because of the current problem of it reading no data as Jan-00 it will always read this as the earliest expiry rather than the actual data entered. What can I do, or what formula is needed to fix this.

2. ## Re: formulation of an expiry summary

put it as: =IF(Sheet1!A1="","",Sheet1!A1)
That should hopefully clear up both issues
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"croberts" <croberts.1wiked_1128657939.007@excelforum-nospam.com> wrote in
message news:croberts.1wiked_1128657939.007@excelforum-nospam.com...
>
> I am trying to create a summary sheet in my workbook which
> will show the earliest expiry dates for a particular item. The dates
> are entered into other worksheets in the workbook and are linked to the
> summary worksheet, however the problem that I am finding is that if no
> data (date) is entered into a cell under a particular heading on one
> of the other worksheets, it is coming up on the summary sheet as
> Jan-00. How do I get rid of this ?
>
> The next problem is that I need a formula that will recognise the
> earliest expiry date. I have tried the =MIN but because of the current
> problem of it reading no data as Jan-00 it will always read this as the
> earliest expiry rather than the actual data entered. What can I do, or
> what formula is needed to fix this.
>
>
> anyone else.
>
>
> --
> croberts
> ------------------------------------------------------------------------
> croberts's Profile:

http://www.excelforum.com/member.php...o&userid=27902
>

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1