Myrna,

No the breaks I was referring to are line breaks, which you won't see as a
character, but in the formula bar it will span 3 lines. The & in Frank's
formula are necessary for it to work.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Myrna" wrote in message
...
Bob,
I pasted the formula to note pad. Brought it on one line.
Are the Breaks the &????


"Bob Phillips" wrote:

You should not change Filename, it is just telling Cell function what
attribute it wants.

Frank's formula, as appeared in the NG, spanned 3 lines. Make sure that
you
get it all onto the one line, remove the breaks.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Myrna" wrote in message
...
Frank,
Had troubles with your formula.

Copied Nov A34
Paste Special to Dec sheet in A5
This was the link: ='Nov (04)'!$A$34
Place a +1 on end: ='Nov (04)'!$A$34+1
Since I copied Nov worksheet to make Dec (identical format)
The Date and year 12/1 and all the data changes below.

Question: Is this the hard way of doing it????


Great Wed showed up.
Dragged my fill down and worked great.



"Frank Kabel" wrote:

Hi
try the following formula in cell A1:
=--("2004" & "-" &
LEFT(MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255),3)
&
"-1")

--
Regards
Frank Kabel
Frankfurt, Germany

"Myrna" schrieb im Newsbeitrag
...
Hi,
I have a seperate file with the current day set.
I created a folder for Payroll
I created a file called Payroll
My November (04) worksheet has the start day inserted.
A1 = Start_Day inserted correctly.
A2 cell has =IF(A1="",""a1+1)
Great I dragged A2 to A34
Worked perfect.
There is some month with 31 days this is why I stopped here.

I copied this spreadsheet and made a workbook. Now called Dec (04)
How do link the start day with this new month for Dec.
Myrna
--
Thank you