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


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

Col B
Approx Age in Weeks

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
with 0 decimals.
Thank you in advance for any assistance!