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