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




"Max" wrote:

Can you post your formula that's misbehaving?

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,400 Files:358 Subscribers:55
xdemechanik
---