software

I am making sheet to check the receipt and ctalog of pay stubs.
I get one every two weeks.
I have been using:
A1 has the header quot;CY 06quot;
A2 has the week quot;01-13-06quot; (Formar Cell, Date quot;03-08-98quot; Note: Office 2000)
A3 had formula =A2 14
This reutrns #VALUE!
whereas this formula in cells B3, C3, D3, E3 for the headers quot;CY 07quot;, quot;CY
08quot;, quot;CY 09quot;, quot;CY 10quot; returns the entered date plus fourteen days.
I went over to the K column added the date quot;01-13-06quot; and tried again and
got the same error.
Is there something about this date in Excel that is... cosmic? It did
comopensate for the leap-year in CY 08. So... ?

Are you sure A2 is actually a number formatted as date, or could it be text.
Text would give this problem.

--
Ian
--
quot;Armorquot; gt; wrote in message
...
gt;I am making sheet to check the receipt and ctalog of pay stubs.
gt; I get one every two weeks.
gt; I have been using:
gt; A1 has the header quot;CY 06quot;
gt; A2 has the week quot;01-13-06quot; (Formar Cell, Date quot;03-08-98quot; Note: Office
gt; 2000)
gt; A3 had formula =A2 14
gt; This reutrns #VALUE!
gt; whereas this formula in cells B3, C3, D3, E3 for the headers quot;CY 07quot;, quot;CY
gt; 08quot;, quot;CY 09quot;, quot;CY 10quot; returns the entered date plus fourteen days.
gt; I went over to the K column added the date quot;01-13-06quot; and tried again and
gt; got the same error.
gt; Is there something about this date in Excel that is... cosmic? It did
gt; comopensate for the leap-year in CY 08. So... ?
Yes, in fact the range A1:A28 a
Format gt;Cells gt;Category gt;Date gt;03-Mar-98
I even tried:
Format gt;Cells gt;Category gt;Custom gt;dd-mmm-yy
And only the A2 gt; A28 has an issue with the date.
I went to column K, K1 cell, entered quot;01-13-06quot; which returned quot;13-Jan-06quot;.
In K2 entered quot;=K1 14quot; which returned quot;#VALUE!quot;
Every other cell I enter a date other than quot;01-13-06quot; and add 14 days in the
next lower cell, returns the date plus 14 days. I can then drag for
quot;auto-fillquot; until I get an end-of-the-year for December and get dates 14 days
apart.

I don't get it.
quot;Ianquot; wrote:

gt; Are you sure A2 is actually a number formatted as date, or could it be text.
gt; Text would give this problem.
gt;
gt; --
gt; Ian
gt; --
gt; quot;Armorquot; gt; wrote in message
gt; ...
gt; gt;I am making sheet to check the receipt and ctalog of pay stubs.
gt; gt; I get one every two weeks.
gt; gt; I have been using:
gt; gt; A1 has the header quot;CY 06quot;
gt; gt; A2 has the week quot;01-13-06quot; (Formar Cell, Date quot;03-08-98quot; Note: Office
gt; gt; 2000)
gt; gt; A3 had formula =A2 14
gt; gt; This reutrns #VALUE!
gt; gt; whereas this formula in cells B3, C3, D3, E3 for the headers quot;CY 07quot;, quot;CY
gt; gt; 08quot;, quot;CY 09quot;, quot;CY 10quot; returns the entered date plus fourteen days.
gt; gt; I went over to the K column added the date quot;01-13-06quot; and tried again and
gt; gt; got the same error.
gt; gt; Is there something about this date in Excel that is... cosmic? It did
gt; gt; comopensate for the leap-year in CY 08. So... ?
gt;
gt;
gt;

This used to happen to me too when formatting dates. That way can be
misleading unfortunately. The best way to verify if a date is text or number
is by using this formula. =isnumber(place cell reference here). This will
return True or False. =istext will work too.

To change a date text to number you can simply multiply the cell by 1. e.g.
=A1*1.

quot;Armorquot; wrote:

gt; Yes, in fact the range A1:A28 a
gt; Format gt;Cells gt;Category gt;Date gt;03-Mar-98
gt; I even tried:
gt; Format gt;Cells gt;Category gt;Custom gt;dd-mmm-yy
gt; And only the A2 gt; A28 has an issue with the date.
gt; I went to column K, K1 cell, entered quot;01-13-06quot; which returned quot;13-Jan-06quot;.
gt; In K2 entered quot;=K1 14quot; which returned quot;#VALUE!quot;
gt; Every other cell I enter a date other than quot;01-13-06quot; and add 14 days in the
gt; next lower cell, returns the date plus 14 days. I can then drag for
gt; quot;auto-fillquot; until I get an end-of-the-year for December and get dates 14 days
gt; apart.
gt;
gt; I don't get it.
gt; quot;Ianquot; wrote:
gt;
gt; gt; Are you sure A2 is actually a number formatted as date, or could it be text.
gt; gt; Text would give this problem.
gt; gt;
gt; gt; --
gt; gt; Ian
gt; gt; --
gt; gt; quot;Armorquot; gt; wrote in message
gt; gt; ...
gt; gt; gt;I am making sheet to check the receipt and ctalog of pay stubs.
gt; gt; gt; I get one every two weeks.
gt; gt; gt; I have been using:
gt; gt; gt; A1 has the header quot;CY 06quot;
gt; gt; gt; A2 has the week quot;01-13-06quot; (Formar Cell, Date quot;03-08-98quot; Note: Office
gt; gt; gt; 2000)
gt; gt; gt; A3 had formula =A2 14
gt; gt; gt; This reutrns #VALUE!
gt; gt; gt; whereas this formula in cells B3, C3, D3, E3 for the headers quot;CY 07quot;, quot;CY
gt; gt; gt; 08quot;, quot;CY 09quot;, quot;CY 10quot; returns the entered date plus fourteen days.
gt; gt; gt; I went over to the K column added the date quot;01-13-06quot; and tried again and
gt; gt; gt; got the same error.
gt; gt; gt; Is there something about this date in Excel that is... cosmic? It did
gt; gt; gt; comopensate for the leap-year in CY 08. So... ?
gt; gt;
gt; gt;
gt; gt;

Yes, I will try this. As an aside, I took the file to work to tinker with
it. Here, I have Excel 2003 and I did not get the error. So, I am thinking
what you say maybe true, but I have tried to isolate any and all formatting
of thecell and actualltrying to chage the format from a date to general and
back to try an remove any quot;pre-dispositionquot; to the format. I will let you
know.
Thank You.

quot;mrscottquot; wrote:

gt; This used to happen to me too when formatting dates. That way can be
gt; misleading unfortunately. The best way to verify if a date is text or number
gt; is by using this formula. =isnumber(place cell reference here). This will
gt; return True or False. =istext will work too.
gt;
gt; To change a date text to number you can simply multiply the cell by 1. e.g.
gt; =A1*1.
gt;
gt; quot;Armorquot; wrote:
gt;
gt; gt; Yes, in fact the range A1:A28 a
gt; gt; Format gt;Cells gt;Category gt;Date gt;03-Mar-98
gt; gt; I even tried:
gt; gt; Format gt;Cells gt;Category gt;Custom gt;dd-mmm-yy
gt; gt; And only the A2 gt; A28 has an issue with the date.
gt; gt; I went to column K, K1 cell, entered quot;01-13-06quot; which returned quot;13-Jan-06quot;.
gt; gt; In K2 entered quot;=K1 14quot; which returned quot;#VALUE!quot;
gt; gt; Every other cell I enter a date other than quot;01-13-06quot; and add 14 days in the
gt; gt; next lower cell, returns the date plus 14 days. I can then drag for
gt; gt; quot;auto-fillquot; until I get an end-of-the-year for December and get dates 14 days
gt; gt; apart.
gt; gt;
gt; gt; I don't get it.
gt; gt; quot;Ianquot; wrote:
gt; gt;
gt; gt; gt; Are you sure A2 is actually a number formatted as date, or could it be text.
gt; gt; gt; Text would give this problem.
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Ian
gt; gt; gt; --
gt; gt; gt; quot;Armorquot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt;I am making sheet to check the receipt and ctalog of pay stubs.
gt; gt; gt; gt; I get one every two weeks.
gt; gt; gt; gt; I have been using:
gt; gt; gt; gt; A1 has the header quot;CY 06quot;
gt; gt; gt; gt; A2 has the week quot;01-13-06quot; (Formar Cell, Date quot;03-08-98quot; Note: Office
gt; gt; gt; gt; 2000)
gt; gt; gt; gt; A3 had formula =A2 14
gt; gt; gt; gt; This reutrns #VALUE!
gt; gt; gt; gt; whereas this formula in cells B3, C3, D3, E3 for the headers quot;CY 07quot;, quot;CY
gt; gt; gt; gt; 08quot;, quot;CY 09quot;, quot;CY 10quot; returns the entered date plus fourteen days.
gt; gt; gt; gt; I went over to the K column added the date quot;01-13-06quot; and tried again and
gt; gt; gt; gt; got the same error.
gt; gt; gt; gt; Is there something about this date in Excel that is... cosmic? It did
gt; gt; gt; gt; comopensate for the leap-year in CY 08. So... ?
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;

MrScott

It would appear that opening it with the 2003 version of Excel has cured any
of the error generating issues. I really do not want to try an replicate the
error. What I did though, was write down your instructions in my system
log... just in case I hit this again. Thank You.

quot;Armorquot; wrote:

gt; Yes, I will try this. As an aside, I took the file to work to tinker with
gt; it. Here, I have Excel 2003 and I did not get the error. So, I am thinking
gt; what you say maybe true, but I have tried to isolate any and all formatting
gt; of thecell and actualltrying to chage the format from a date to general and
gt; back to try an remove any quot;pre-dispositionquot; to the format. I will let you
gt; know.
gt; Thank You.
gt;
gt; quot;mrscottquot; wrote:
gt;
gt; gt; This used to happen to me too when formatting dates. That way can be
gt; gt; misleading unfortunately. The best way to verify if a date is text or number
gt; gt; is by using this formula. =isnumber(place cell reference here). This will
gt; gt; return True or False. =istext will work too.
gt; gt;
gt; gt; To change a date text to number you can simply multiply the cell by 1. e.g.
gt; gt; =A1*1.
gt; gt;
gt; gt; quot;Armorquot; wrote:
gt; gt;
gt; gt; gt; Yes, in fact the range A1:A28 a
gt; gt; gt; Format gt;Cells gt;Category gt;Date gt;03-Mar-98
gt; gt; gt; I even tried:
gt; gt; gt; Format gt;Cells gt;Category gt;Custom gt;dd-mmm-yy
gt; gt; gt; And only the A2 gt; A28 has an issue with the date.
gt; gt; gt; I went to column K, K1 cell, entered quot;01-13-06quot; which returned quot;13-Jan-06quot;.
gt; gt; gt; In K2 entered quot;=K1 14quot; which returned quot;#VALUE!quot;
gt; gt; gt; Every other cell I enter a date other than quot;01-13-06quot; and add 14 days in the
gt; gt; gt; next lower cell, returns the date plus 14 days. I can then drag for
gt; gt; gt; quot;auto-fillquot; until I get an end-of-the-year for December and get dates 14 days
gt; gt; gt; apart.
gt; gt; gt;
gt; gt; gt; I don't get it.
gt; gt; gt; quot;Ianquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Are you sure A2 is actually a number formatted as date, or could it be text.
gt; gt; gt; gt; Text would give this problem.
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt; Ian
gt; gt; gt; gt; --
gt; gt; gt; gt; quot;Armorquot; gt; wrote in message
gt; gt; gt; gt; ...
gt; gt; gt; gt; gt;I am making sheet to check the receipt and ctalog of pay stubs.
gt; gt; gt; gt; gt; I get one every two weeks.
gt; gt; gt; gt; gt; I have been using:
gt; gt; gt; gt; gt; A1 has the header quot;CY 06quot;
gt; gt; gt; gt; gt; A2 has the week quot;01-13-06quot; (Formar Cell, Date quot;03-08-98quot; Note: Office
gt; gt; gt; gt; gt; 2000)
gt; gt; gt; gt; gt; A3 had formula =A2 14
gt; gt; gt; gt; gt; This reutrns #VALUE!
gt; gt; gt; gt; gt; whereas this formula in cells B3, C3, D3, E3 for the headers quot;CY 07quot;, quot;CY
gt; gt; gt; gt; gt; 08quot;, quot;CY 09quot;, quot;CY 10quot; returns the entered date plus fourteen days.
gt; gt; gt; gt; gt; I went over to the K column added the date quot;01-13-06quot; and tried again and
gt; gt; gt; gt; gt; got the same error.
gt; gt; gt; gt; gt; Is there something about this date in Excel that is... cosmic? It did
gt; gt; gt; gt; gt; comopensate for the leap-year in CY 08. So... ?
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;