week dates

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...

🤓 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 –...

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...

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...

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...

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...

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...

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...