Worksheet Functions

I'm not sure that its a worksheet function issue. You might want to try
posting in .programming with the code that's writing stuff into the sheet.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik
---
"Steve Peel" wrote in message
...
The formula in N2 is being overwritten by the date in P2 when ever it is
changed. I fixed the problem by protecting the sheet, but it forced me to
add many unprotect lines in my VBA code - very time consuming.
M N O
P
1
2 Week Ending Date =P2 Week Ending Dates 39690
3 Monday =N2-5
4 Tuesday =N2-4
5 Wednesday =N2-3 LastWeeksTracker =P2-7
6 Thursday =N2-2 ThisWeeksTracker =P2
7 Friday =N2-1 NextWeeksTracker =P2+7
8 Monday =N2+2 SaveBookBoolean Yes

Sorry about the misaligned worksheet I tried to copy in. That would be the
first place I look, but this is happening when I maunally change the date in
cell P2 directly on the sheet. So it is definitely happending during
recalculation.

"Max" wrote:

I'm not sure that its a worksheet function issue. You might want to try
posting in .programming with the code that's writing stuff into the sheet.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik
---
"Steve Peel" wrote in message
...
The formula in N2 is being overwritten by the date in P2 when ever it is
changed. I fixed the problem by protecting the sheet, but it forced me to
add many unprotect lines in my VBA code - very time consuming.
M N O
P
1
2 Week Ending Date =P2 Week Ending Dates 39690
3 Monday =N2-5
4 Tuesday =N2-4
5 Wednesday =N2-3 LastWeeksTracker =P2-7
6 Thursday =N2-2 ThisWeeksTracker =P2
7 Friday =N2-1 NextWeeksTracker =P2+7
8 Monday =N2+2 SaveBookBoolean Yes

Don't have any further clues. Still believe the phenomena you describe has
to do with some code (Worksheet_Calculate?). Why not take it up further in
..programming?
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,400, Files:358, Subscribers:55
xdemechanik
---
"Steve Peel" wrote in message
...
Sorry about the misaligned worksheet I tried to copy in. That would be
the
first place I look, but this is happening when I maunally change the date
in
cell P2 directly on the sheet. So it is definitely happening during
recalculation.