Microsoft Office Forums - View Single Post - Using WEEKNUM to calculate how many weeks from date to today.

Thread: Using WEEKNUM to calculate how many weeks from date to today.

View Single Post

Old

07-02-2013, 06:41 AM

stephen_

stephen_ is offline

stephen_ uses Windows XP

Windows XP stephen_ uses Office 2010 32bit

stephen_ uses Office 2010 32bit

Office 2010 32bit

Novice

The original poster

Join Date: Jun 2012

Posts: 6

stephen_ is on a distinguished road

Default

Okay worked it out - formula is =INT((TODAY()-cell)/7)

Reply With Quote