week dates

  1. G

    Auto Update data weekly help

    Hi I am stuck and need some help please. I have attached a picture of the issue i am having. Basically i have 7.5% in the red box (Cell B2) that i have to update manually. I would like it to auto update each Tuesday of the month with the same % as the week before (orange box's) but if say on...
  2. J

    Formula for weekdays of date in another cell

    I have tried to find the answer but maybe I’m just not wording my query well enough to find the answer, apologies if this has already been asked. Scenario: spreadsheet filled with birthdates, we decorate person’s office/desk the entire week of birthday, with a cupcake the day of. There is...
  3. CubeMonkey

    Week Number based on Day. (Based on United States Government Fiscal Year)

    🤓 Good day my fellow nerds, Today I need guidance on how to figure out the Week Number based on the day. Let me breakout a list of things you will need to know: - The Week # being displayed will be based on the United States Government Fiscal Year 2023 which is: 1st quarter: 1 October 2022 –...
  4. H

    How to lock or show the data including date that user input?

    Hi. I want to create a weekly project tracking. This is the step: 1. User enter the required date to fill in the data 2. The formula will automatically display the required week and Monday date 3. User key in project, start, end, status and manager The problem is: Assume after filling the data...
  5. F

    How to calculate the extra earnings using the highest rate and hours

    I need help figuring out how to calculate employee's extra earnings due to extra hours they worked each week. Let's say, the year starts on November 1st. So the first week of November starting Sunday and ending Saturday is Week #1 (if November 1 starts on a Friday, then Week #1 will consist of 2...
  6. Saher Naji

    Match 2 sets of numbers in 2 cells

    I want to generate a special excel formula. My wish is to find out the last working day of each week. Thus, the formula is designed to analyze consecutive dates and find all Fridays, or, if there is no Friday for a given week, the last working day in the same week before Friday. The Friday or...
  7. R

    Custom week number / Custom Fiscal year

    Hello, I am trying to create a custom week number formula where week starts on Saturday and ends Friday. The fiscal year starts from 02/01/2018 and ends on 01/31/2019 ** This how i want week number list to start and end. The three columns, first column shows week number, second showing...
  8. A

    Formula to calculate monthly values from weekly time series, using days in each week

    I want to calculate monthly values from weekly ones, by taking into account the number of days in the weeks that overlap each month. Below is an example. Row 5 shows the figures I want to calculate, by referencing the rows above. <tbody> 03/05/2015 10/05/2015 17/05/2015 24/05/2015 31/05/2015...
  9. K

    Formula to check if one date is within a range of other dates?

    Sorry if I don't explain this very well, I'll do my best- I need a formula in B1, which will check the date in A1 and tell me if it is within this week's dates. It will say 'This Week' if this is true. (eg. if A1 says: '30/12/2014' (or any other date from the current week) then it will say...

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