View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lisa D Lisa D is offline
external usenet poster
 
Posts: 1
Default Create Calculation to return number of weeks and days

I need to create a formula where it calculates the number of weeks and days
between 2 dates.

For example:
A2 = 12/25/08
B2 = 1/30/09
C2 = 5 weeks 1 day

I found example formulas that calculates years, months and days....but no
weeks.

Any help is most appreciated!
Thanks!