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
From India, Chennai
Acknowledge(0)
Amend(0)
23Check 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
From India, Chennai
Acknowledge(0)Amend(0)
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.
From India, Gurugram
Acknowledge(0)Amend(0)
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.
From India, Gurugram
Acknowledge(0)Amend(0)Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.
EXCEL FORMULA.xls