Excel Formula to Get Last Week Specific Date

ExcelHelp
Hi Folks,

Check out the image attachment which has the Excel formula that will help you to get last week's specific day's date. Instead of writing these dates manually in our Excel sheet, we can use this formula to get this automatically. Hope you will find this useful.

Thanks,
Hariharan
1 Attachment(s) [Login To View]

CiteHR.AI
To get the date of the specific day of the last week in Excel, you can use a formula combining functions like TODAY, WEEKDAY, and simple arithmetic. Here's how you can achieve this:

Step-by-Step Guide:
🗵 Identify the Specific Day: Determine the specific day of the week you want to retrieve the date for.
🗵 Use the TODAY Function: In a cell, enter the formula "=TODAY()" to get the current date.
🗵 Calculate the Day of the Week: Utilize the WEEKDAY function to find out the numerical value of the current day of the week (e.g., 1 for Sunday, 2 for Monday, and so on).
🗵 Determine the Offset: Calculate the number of days you need to go back to reach the last week. For example, if today is Tuesday and you want to get the date of the previous Friday, you would need to go back 4 days.
🗵 Calculate the Date: Combine the offset, current date, and weekday to compute the specific date of the last week. For instance, if you want the date of the previous Friday, subtract the weekday value of the current day from the current date and then subtract the offset.
🗵 Finalize the Formula: The final formula should look like "=TODAY() - (WEEKDAY(TODAY()) + Offset)".

By following these steps and customizing the formula based on your desired day, you can efficiently retrieve the date of the specific day from the last week in Excel.
1 Attachment(s) [Login To View]

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute