once again I am here for help, I've read hundreds of tutorials on how to fill dates, get every 1st and 3rd day, every Monday ect ect.. but none of them seem to account for the 28 or 29 days in February..
In my sheets, the month is pulled from the sheet name, then converted to a number, the year...
Experts, I am attempting to make a payroll calendar and paycheck distribution date.
I have the start date in A1 and to make my bi-monthly dates, A2 has the formula =IF(DAY(A1)<15,DATE(YEAR(A1),MONTH(A1),15),DATE(YEAR(A1),MONTH(A1)+1,0))
I am trying to place a formula in A3 that would calculate...
Why am i getting #DIV/0! ???
I need a formula, way to input the dates of every Wednesday and Friday since 01/07/2105
so for example the dates I require int he pattern would be:
01.07.15 03.07.15 08.07.15 10.07.15 15.07.15 17.07.15
and so on - every Wednesday and Friday.
Rather than typing out the actual date is...
Hello All! I am looking for a way to count the difference in days between a PickUp (PU) date and the Delivery (Del) date of a shipment. For example, if PU date is 3/3/14 and the Del date is 3/12/14 I would like a formula to tell me how many weekdays are within this range. Can anyone help?
We have weekend projects that start on Fridays and I know I can create a list on a separate worksheet but I would like to avoid this.
I think I need a Data Validation formula using WEEKDAY in it.
I have a form that has dates that need to be populated based on a numerical code placed into cell H46. I have the number of days for the 13 codes listed on another tab called Dates. The formula I'm currently using takes weekends into consideration and I only want the dates to count weekdays...
Apparently, I have jello for brains at this point, because this seems so simple. Anyway, I have the following formula in cell K14 and want another cell to display the day of the week based on this cell.
For some reason, using the...
Here's my problem: I'm looking for a formula to change a weekday in the previous month - the day that is 30 days from a day in this month - to a Monday of the following week, if it's a weekday oother than a Monday. For example, if 30 days from the current month (June) is May 24, 2012...
i have a bunch of dates in column B that are populated from an external feed into excel. the dates are populated starting at cell B5 and going down X number of rows...X because the dates could go down 5 rows or 50 depending on what the external feed populates into excel, but never over 200...
I am trying to make a column for week numbers that either needs to start on thursday or end on thursday, right now i have =WEEKNUM(A4,2) and i think i need to change the 2 but im not sure really appreciate the help!
I making some planning for my company and they make all the calculations as a working days. I need something like this:
Cell A=Starting date
Cell B= End date
Cell C= Number of working days
I want that cell B get calculated starting from A and adding C and the corresponding weekend...
Hey, has anyone ever noticed that the WEEKDAY function returns #Value if your region in the Control Panel is set to Hungarian or Chinese (or possibly others)? I have written some worksheets that are being used globally and discovered this problem when some users in these locations said the...
In Microsoft Excel, I would like to subtract Saturday, Sunday, & Monday from the days of the week and still have the formula give me a calculated day. Right now I have a WEEKDAY formula that calculates 29 days subtracted from a final date (i.e. January 22, 2010 - 29 --> final answer Dec 15...