Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-25-2014, 10:04 AM
gebobs gebobs is offline Remove week 53 from excel Windows 7 64bit Remove week 53 from excel Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Take a look at what I have attached.

To test, enter the date you want (e.g. today's date) into the highlighted cell.

The table beneath give the number of weeks back from the test date (1 -65...so goes back over a year), the start date, the end date and the number I think you're looking for, the week number.

There are probably more elegant solutions.
Attached Files
File Type: xlsx YounesB3.xlsx (12.4 KB, 18 views)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Remove week 53 from excel Week by week report thedeadzeds Excel 3 11-16-2013 02:06 AM
Remove week 53 from excel Need an excel formula to remove dashes in a number sequence jyfuller Excel Programming 3 02-27-2013 10:32 PM
Remove week 53 from excel 5 days/week during planning & 7 days/week during implementation sanlen Project 1 06-25-2012 04:17 PM
Remove week 53 from excel Conditional Formatting per Week mrgy05 Excel 2 06-07-2012 10:38 AM
MS Excel Remove password encryption Rio Pauline Excel 1 05-29-2012 03:34 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:04 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft