Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-25-2014, 06:50 AM
YounesB3 YounesB3 is offline Remove week 53 from excel Windows XP Remove week 53 from excel Office 2010 32bit
Advanced Beginner
Remove week 53 from excel
 
Join Date: Jul 2012
Posts: 37
YounesB3 is on a distinguished road
Default Remove week 53 from excel

Hello, I was wondering if it was possible to remove week 53 from excel.

WEEKNUM(TODAY()-(7*11)) = 2


WEEKNUM(TODAY()-(7*12)) = 53
WEEKNUM(TODAY()-(7*13)) = 52

The database I'm using doesn't have a week 53. I'd like the 53 to be 1.

I had found a solution by converting everything with system 2 (WEEKNUM(TODAY()-(7*?),21)). The thing is, I also have a year function i.e. YEAR(TODAY()-(7*?)).

So basically, I would have XYZ-1-2013 instead of XYZ-1-2014.

Any solutions to this?

Cross post : http://www.mrexcel.com/forum/excel-q...ml#post3758264
Reply With Quote
 



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 07:09 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