Date calculation between cells & textbox

[marlowem]

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I have a textbox that a user would input a date into (normal textbox on a worksheet rather than a form). I also have a date stored in a specific cell on a different worksheet. <o></o>
<o></o>
I'd like to display the difference in weeks between the 2 dates in a separate textbox and wondered where to start with the coding for this? <o></o>
<o></o>
Any help appreciated<o></o>
<o></o>
Thanks in advance <o></o>

 

[drsarao]

Excel stores dates as numbers.
So you need to do:
Get date date from user (date1 eg)
Read date from the specific cell (say date2)
Subtract and divide by 7 - (date1-date2)/7
Plug the result in the text box after shedding the decimal part.