weekday

How can I get excel to tell me the dates of: The first Tuesday of every month? (this should include 12 dates). The second Thursday of every three months? (this is 4 dates). The third Friday of every month? (this is 12 dates). I am trying to come up with a way to establish the dates of cycle...

Hi All, I am working on an Excel forumla to calculate a schedule date for an order. It needs to take the date in column C and add 14 days to it. It also accounts for work holidays, by adjusting how many days are added to the original date. That's the simple part. Where I am having issues...

I need to be able to count the number of Mondays in a date range and subtract the Mondays which are holidays. By reading this message board I have found a nice way to count the number of Mondays in a date range: Let A1 contain the start date and A2 contain the end date, then...

Hi all, I made a sheet a long time ago and need to modify it a bit. One of the cells calculates how many work days are within two days, I had some help doing this one, and I'm using this formula: =IF(J6="",0,SUM(INT((WEEKDAY(J6-{2,3,4,5,6,7})+K6-J6)/7))) I need to modify this formula in...

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

In column B, I have dates. I need to figure out what the first working day in that week was, and populate that date in another column. For e.g., if I had 1/13/11 in B2, then in C2, I want the date 1/10/11. I am trying to figure out how many events I had each week. My thought is to do a pivot...

Hi The following function calculate the last "Monday" value in MS Access (SQL) but I would like to calculate the "last Friday" of the week and could some one go through how this fucntion work (break down) please. I need to get the understanding so in future I can do my self instead of...

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!

Hi, I need to show a dynamic list of dates in the current month, but excluding weekends e.g. 1/4/10 2/4/10 5/4/10 6/4/10 7/4/10 8/4/10 9/4/10 12/4/10 I am able to get a full list of dates as shown below, and I can also identify which dates are weekends, however I need a continuous list...

Hello, I would like to use a formula to take the starting date in cell A1 and then have Excel give me a list of all the dates for 2009 excluding Sundays. So A1 would be 1/01/09 Then Excel would list Thursday, Jan 01 Friday, Jan 02 Saturday, Jan 03 Monday, Jan 05 Tuesday, Jan 06 etc.... I've...

A while ago I asked for help in compiling a formula that would act as a daily check on puzzle numbers that appear in a newspaper. The daily crossword would appear from Monday to Saturday (but not on Sundays or on Christmas Day) The formula some genius in the forum came up with was...