![]() |
#1
|
|||
|
|||
![]()
I'd like to add a simple formula to calculate the number of weeks from a date entered into a cell to the current date.
I'm trying to use the WEEKNUM formula to no avail? |
#2
|
|||
|
|||
![]()
Okay worked it out - formula is =INT((TODAY()-cell)/7)
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
BrazzellMarketing | Outlook | 7 | 08-15-2013 07:32 AM |
![]() |
freschij | Excel | 3 | 02-11-2011 10:21 AM |
Creating an Auto-Calc'd Date? Today+7 Days? | SoCalTelephone | Word | 0 | 10-06-2010 10:27 AM |
new appointment date always reverts back to today's date | msills | Outlook | 0 | 08-24-2007 08:57 AM |
![]() |
promark | Outlook | 1 | 12-23-2005 07:21 AM |