How To Calculate Week Ending Date

preview_player
Показать описание
How to calculate week ending date in Excel for any day of the week.
Рекомендации по теме
Комментарии
Автор

I need to get a series of weekending dates as a header on a form. Is there a fast way to get a list of weekending dates

deegadams
Автор

good, it help me actually to solve a chegg question 👍

hans
Автор

What would be the difference between using the return type 1 mapping scheme (Sunday-Saturday) vs return type 17 mapping scheme (Sunday-Saturday)?

MonicaFrieson
Автор

nice and good job. but please put all excel practiced files in the description....

ubaidillahmuhammad
Автор

Not sure if this is being monitored, but this video is close to what I'm trying to achieve.
So I have a timesheet that has a WEEK ENDING cell and our work weeks are Sun. thru Sat. So I put the date in that cell, (ex: 10/31/2020)

Now in the rest of the timesheet there are columns for each day of the week. So I know how to get the Saturday's column date cell to copy the week ending cell by using the formula =AG1. So now Saturday's date cell is filled in. What I want to happen next is I want the remaining days of the week to autofill each days date cell going back to Sunday's date cell. Sunday would be 10/25/2020. How do I achieve this?

GratefulHippie