Determining number of weeks between dates

  • Thread starter Thread starter goonboy175
  • Start date Start date
G

goonboy175

Hello all, wonder if anyone can help me out with this question. In
database I need to say how many weeks are left between two dates. Fo
example 21/05/04 and 31/03/05. Anyone have any ideas how to do this
Any help much appreciated
 
How accurate do you want it?

You could simply subtract one from the other and divide by 7

e.g

=(A1/B1)/7

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Back
Top