Determining number of weeks between dates

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
 
N

Nick Hodge

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating number of weeks between dates (start and end dates) 1
how to create a chart in excel base on date? 1
Problem formatting dates from CSV file 2
Calculating number of weeks between dates? 2
Charts based on Different Dates 2
Subtracting dates into weeks... 3
Sum value between two dates and copy to new cell 6
Calculating a week between a range of dates 3

Top