how can i determine number of weeks between 2 dates

S

Sandy Mann

=INT((A2-A1)/7)

Where A2 is the later date

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 

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

why does excel change my numbers? 3
How do I keep the 0 at the beginning of a number, ex. 090? 0
ERASE THE "NUMBER 1" IN THE MIDDLE OF SPREADSHEET 0
how do i format an excel cell for stopwatch times mm:ss? 0
HI, I want to 5-9 as age group but it comes as 05 sept date forma 0
12MMT - How ? 5
what formula do you use to get the name of a tab? 1
O.T. What's happening in the Newsgroups? 5

Top