week end date

  1. F

    VBA Holiday Dates by Week End Date

    Hi All I'm not sure if something like this is possible so i thought i'd ask. Currently we have a system where we store our holiday dates and we need to update another spreadsheet from this but it is not exported in a friendly fashion for this. Please see below as i have a description of each...
  2. Hrishi

    How to calculate last date of a week from any date assuming that week starts on monday

    Hello, I want to calculate the last date of a week from any date with presumption that week starts from monday and ends on sunday. I have a formula =IF(WEEKDAY(date)=7,date+1,date+(7-WEEKDAY(date)),,, BUT this does not work on date 1-1-17 and 31-12-18 etc may be it because this day is either...
  3. I

    Weekend date

    I want calculations that will automatically give me a given Monday's date on a rolling 8 week cadence. Once past a date the field would give the next Monday two months away's date. I've attached an ex. of what outputs would look like for diven dates. Self-contained is ideal, but can reference...
  4. C

    Return week ending date from Week Number

    Hi there, I have a dataset that is entered daily into the date column (Column B) of a worksheet. Each daily entry has the corresponding week number placed next to it through the WeekNum function (Column A), which has weeks of the year marked as numbers (27, 28, 29, 30 etc.). I am using the week...
  5. M

    Formula for Week Ending Date (Saturday)

    Is there an excel formula that will calculate the week ending (Saturday) date for the specified cells? I have found WEEKNUM and Week Start formulas, but not week ending date. Thanks.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top