2013年3月12日 · Excel treats each day as 1 for every day past Dec 31, 1899. Today happens to be 41,346 and next Sunday is 41,350 . The WEEKDAY() function in its default form returns a number representing the day-of-the-week with Sunday starting as 1 to Saturday as 7 .

2007年6月22日 · I need help with a formula. I have a certain list of dates, by day...and I need them listed by "week ending" (where a week "ends" on a Sunday). For example, for the week ending 5/23, I might have the dates: 5/23/10 (Sunday) - the formula should pull 5/23/10 5/22/10 (Saturday) - the formula should pull 5/23/10

2014年4月21日 · Welcome to the Board! Here is a formula to get the Saturday week ending date of any date (entered into cell A1, in this example):

2018年8月28日 · I have a date (displayed for example 25-Jul) in A1 column, it is a formula itself, not sure if this makes the difference. I am needing the Sunday date for this week (weeks Monday to Sunday), so it will always be a later date unless the date is a Sunday. So if A1 = 25-Jul which is a Wednesday, then the returned value needs to be 29-Jul. Thanks

2010年9月9日 · What formula would I use to automatically show the prior sundays date providing it was monday-saturday, and the current date if the day was sunday? This thread is locked. You can vote as helpful, but you cannot reply or subscribe to this thread.

2012年6月29日 · I am trying to create a week ending formula in excel. I have a list of dates and in a new column I would like to display the week ending of these dates. I want the weeks to end on Sunday. For example, if the date column has the date 7/24/12 in it, I would like the week ending formula to spit out...

2015年4月6日 · I need to create a formula that will display different week ending dates in Excel, where I do not have to enter them in manually. I am entering in week ending dates from 11/8/2013 thru 12/29/2017. SOMEBODY PLEASE HELP!!!!

2020年8月25日 · I'm trying to put week ending formula on my excel file but I couldn't figure out why it is not showing the way I want to show. I want the formula to display, WE 24/08/2020 . But on the formula I've used, it shows WE 44067 .

2010年8月23日 · Excel considers Saturday the end of the week, so therefore when WEEKDAY is used, it gives it a number of 7, which would would indicate the end. However, if we think of a week as a "container" that is filled by 7 days, by the time we hit Saturday excel considers the week "full" week, so when we use the MOD function to find the remainder, there ...

2002年5月23日 · Hello, In Column H I have dates e.g. 8-Nov-21 I need a formula for column I that calculates the week ending date which will always be a Friday. So in this case 8-Nov-21 is a Monday so the week ending date to be populated in column I is 12-Nov-21. If the date in column H was 17-Nov-21 week...