Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-03-2017, 10:52 AM
Ktyler Ktyler is offline Need Excel to recognize week numbers based on specific dates Windows 7 64bit Need Excel to recognize week numbers based on specific dates Office 2016
Novice
Need Excel to recognize week numbers based on specific dates
 
Join Date: Feb 2017
Posts: 4
Ktyler is on a distinguished road
Default Need Excel to recognize week numbers based on specific dates

I need Excel to automatically provide me a week number based off of a starting date (01/01/2017) and other dates to follow. For example, week number 1 starts off with January 2nd 2017 (since the first week of the year starts on the first full week in the month [January 1st would actually fall under week 52]) So any date entered from January 2nd - January 8th would be considered week 1, January 9th - January 15th would be considered week 2, etc...



Can someone help me by developing a formula that suits what I am looking for?

Many thanks!!
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel copy two numbers between specific column and paste in next sheet visha_1984 Excel 1 12-26-2014 07:59 PM
Need Excel to recognize week numbers based on specific dates Excel VBA Macro - Deleting Specific Data based on criteria MD011 Excel Programming 3 12-10-2014 02:15 AM
Need Excel to recognize week numbers based on specific dates Auto populating dates on timesheet for week from one inputted date ohi Word VBA 3 12-04-2014 12:11 PM
Need Excel to recognize week numbers based on specific dates Excel to auto populate dates based on start and end patidallas22 Excel Programming 9 04-21-2014 03:14 PM
Need Excel to recognize week numbers based on specific dates Formula to auto calculate Day of the week based on Date prasad@dmci.ca Excel 1 11-29-2011 01:05 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:13 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