G
Guest
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 "CY 06"
A2 has the week "01-13-06" (Formar Cell, Date "03-08-98" Note: Office 2000)
A3 had formula =A2+14
This reutrns #VALUE!
whereas this formula in cells B3, C3, D3, E3 for the headers "CY 07", "CY
08", "CY 09", "CY 10" returns the entered date plus fourteen days.
I went over to the K column added the date "01-13-06" 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... ?
I get one every two weeks.
I have been using:
A1 has the header "CY 06"
A2 has the week "01-13-06" (Formar Cell, Date "03-08-98" Note: Office 2000)
A3 had formula =A2+14
This reutrns #VALUE!
whereas this formula in cells B3, C3, D3, E3 for the headers "CY 07", "CY
08", "CY 09", "CY 10" returns the entered date plus fourteen days.
I went over to the K column added the date "01-13-06" 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... ?