![]() ![]() I hope you found this Excel tutorial useful. While I have covered the examples that show how to add weeks to a date in Excel, you can use the same methods to subtract weeks from a date as well. The WEEKNUM function is used in Excel to return the week number of a specific date in the year (a number between 1 and 54). So these are two easy ways you can use to quickly add a week (or any given number of weeks) to a date in Excel. ![]() In case you want to add different week values to different dates, you will have to use the formula method only MyWeekDay Weekday (MyDate) ' MyWeekDay contains 4 because ' MyDate represents a Wednesday. ![]() You can use this to calculate the weeknumber. VB Dim MyDate, MyWeekDay MyDate Febru' Assign a date. According to the ISO criteria the first thursday of any year is always in week 1. Note: One limitation of this Paste Special method is that you will only be able to add one given week value to all the given dates. This example uses the Weekday function to obtain the day of the week from a specified date. In case you want to show the start date as well as the resulting date after the weeks have been added, copy the dates in a separate column and then use Paste Special on the copied data.Īlso, if you may need the original data in the future, it’s a good idea to make a backup copy of your workbook, or copy the dates data in a separate column and then use Paste Special to add a week to the date. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |