![]() ![]() To do so, first, we will multiply the weeks by 7 to convert them into days and then, use the Paste Specialcommand to add them to a particular date. In this method, we will use this command to add weeks to a particular date. The Paste Specialcommand lets users to paste a particular text, picture or other objects according to their preferences. Read More: How Do I Add 7 Days to a Date in Excel (5 Methods) Finally, lower the cursor to autofill the rest of the cells.As a result, we will get the new date from addition of weeks to the previous date.To begin with, select the E5 cell and write the following formula down,. ![]() Firstly, we will convert the weeks into days by multiplying them with 7 and then use the SUM functionto sum the existing date to the calculated days. In this instance, we will use the SUM function to do the trick.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |