Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
s s is offline
external usenet poster
 
Posts: 36
Default Calculate difference between current date & prior

I am looking for a formula that would calculate the difference in dates but
display in weeks-can this even be done?

Col A
Date Received
4/15/2010


Col B
Approx Age in Weeks
2

I am trying to calculate the current age in weeks but cannot come up with
the right formula. The closest I could get was using TODAY() but kept
getting the errors. I have the formatting for the results col. set as number
with 0 decimals.
Thank you in advance for any assistance!
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: Calculate difference between current date & prior

Calculating the Difference Between Two Dates in Weeks in Microsoft Excel
  1. Subtract the prior date from the current date to get the difference in days:
    Formula:
    =TODAY()-A2 
  2. Convert the difference in days to weeks by dividing by 7:
    Formula:
    =(TODAY()-A2)/
  3. Enter the formula in the cell next to the prior date to calculate the approximate age in weeks.

Note: This formula only gives an approximate age in weeks, rounding down to the nearest whole week. For a more precise age in weeks, use a more complex formula that takes into account the number of days remaining after dividing by 7.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 457
Default Calculate difference between current date & prior

=INT((TODAY()-A2)/7)

or

=ROUND((TODAY()-A2)/7)

--
Best Regards,

Luke M
"S" wrote in message
...
I am looking for a formula that would calculate the difference in dates but
display in weeks-can this even be done?

Col A
Date Received
4/15/2010


Col B
Approx Age in Weeks
2

I am trying to calculate the current age in weeks but cannot come up with
the right formula. The closest I could get was using TODAY() but kept
getting the errors. I have the formatting for the results col. set as
number
with 0 decimals.
Thank you in advance for any assistance!




  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,440
Default Calculate difference between current date & prior

=(TODAY()-A2)/7

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"S" wrote in message
...
I am looking for a formula that would calculate the difference in dates but
display in weeks-can this even be done?

Col A
Date Received
4/15/2010


Col B
Approx Age in Weeks
2

I am trying to calculate the current age in weeks but cannot come up with
the right formula. The closest I could get was using TODAY() but kept
getting the errors. I have the formatting for the results col. set as
number
with 0 decimals.
Thank you in advance for any assistance!


  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
s s is offline
external usenet poster
 
Posts: 36
Default Calculate difference between current date & prior

Works perfectly! Thank you so much - it was the /7 that I was missing... DUH!

"Niek Otten" wrote:

=(TODAY()-A2)/7

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"S" wrote in message
...
I am looking for a formula that would calculate the difference in dates but
display in weeks-can this even be done?

Col A
Date Received
4/15/2010


Col B
Approx Age in Weeks
2

I am trying to calculate the current age in weeks but cannot come up with
the right formula. The closest I could get was using TODAY() but kept
getting the errors. I have the formatting for the results col. set as
number
with 0 decimals.
Thank you in advance for any assistance!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate Difference in Times with Considering Date CB Excel Worksheet Functions 4 May 23rd 07 03:58 PM
How to calculate person's age from DOB and current date? greg2dan Excel Discussion (Misc queries) 1 February 12th 07 04:28 PM
calculate prior calendar year end from a moving current date Louise Excel Worksheet Functions 1 December 6th 06 08:48 PM
Calculate current date from fixed time? mandg Excel Worksheet Functions 2 June 1st 06 03:26 PM
formula to calculate age using birth date and current date lalah Excel Worksheet Functions 2 November 20th 05 10:51 PM


All times are GMT +1. The time now is 09:46 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"