#1
|
|||
|
|||
Using WEEKNUM to calculate how many weeks from date to today.
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 |