If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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! |
#3
|
|||
|
|||
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! |
#4
|
|||
|
|||
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! |
Thread Tools | |
Display Modes | |
|
|