![]() |
|
#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)
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Show date instead of Today, Yesterday . .
|
BrazzellMarketing | Outlook | 7 | 08-15-2013 07:32 AM |
Today's Date Function
|
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 |
Imported message date change to today's date
|
promark | Outlook | 1 | 12-23-2005 07:21 AM |