date calculation

Hi, I have a date-time column [CreatedOn] e.g. 11/08/2010 11:31. I need a formula to extract the year e.g 2010 and then set the day to 01 and the month to 06 and the time to 00:00 and return this as a date-time value. The formula might need to be two parts extract the year from the CreatedOn...

Hi I am using MS Query to return data into Excel. I know Access but am quite new to MS Query and keep finding vast differences between the two!! I've looked on the help but it doesn't seem to be of any! I have two date fields which are formatted as dd/mm/yyyy hh:mm - and I need to take one...

Hi! Your help is greatly appreciated! Bid openings are always on Wednesday. Advertisement dates can be any weekday. A project must be advertised for a minimum of four weeks (holidays, weekends not excluded). I need to calculate a date, based on the (advertisement date) that is a *Wednesday*...

Here is the scenario: I have Column A that holds the date and Column B that shows many days have passed since that day in Column A passed. For example - if the date in Column A is 7/1/2010, Column B shows 8 because a total of 8 days passed from the value in Column A up to today's date...

Hi, I've searched through the board and haven't found an answer to my question. Forgive me if this is a repeat. I have an Excel 07 report that contains a date value (date1) in column F and another date value (date2) in column AA. I need to use conditional formatting to highlight rows where Col...

Hi I'm trying to put together a sickness calculator that works on a rolling year basis. I need to count the number of days between two dates, but only count the working days, which are Tuesday, Wednesday, Friday and Saturday (so exclude Mondays, Thursdays, Sundays and bank holidays) and only...

I need a formula to put in B4 that will take the date in A4 and add the proper amount of days based on what the Start Date (will change frequently) is. So, in this example the correct date that should appear in B4 is 6/10/09. I have a couple more examples below. <TABLE style="WIDTH: 133pt...

Hello everybody! I'd like that when data is stored in a cell, the cell in the next column in the same line give me the date in wich it occurred. It seems simple at start but I'm not good at all with VBA. Tks!!!

Hi--can anyone help me with the following? I want to automatically invoke the TODAY() function in Column P, by row, whenever anything in columns A-O is updated within each particular row. It's for a spreadsheet where line items will be regularly updated over time, and I want to capture how...

I need a datedif formula to look at the months and days between two dates and display only the months. However, i need the result (number of months) to be rounded up if the days are 15 or more and rounded down if 14 or less. right now i'm using this formula, but i'm not sure how or where to...

I've built a tool that counts days from a given date and spits out a target date. It counts saturdays and sundays, excludes holidays, and if it lands on a sat or sun the target date is moved to the following monday (target date can't land on a weekend). If the target date lands on a holiday it...

I have two cells in EXCEL, one with a beginning date and one with an ending date. I need to get a value of "0" when the range between the dates includes 2/29/08. If 2/29/08 is not in the range I need a value of 1. I am subtracting the beginning date from the ending to get the number of days...

Along the top of my spreadsheet are dates that fall on the same day every week. However, the day of the week is not always a Monday or a Tuesday. It depends on a different user input. When the user puts in a new event down below and selects the dates it will fall on, the appropriate cells...

I have a workbook that teachers use to mark attendance for their class each day. There are two worksheets for each month - one for morning and one for afternoon (named Jan AM and Jan PM, Feb AM and Feb PM etc). The morning attendance sheet automatically updates the afternoon sheet with each...

Hi, Would it be possible to calculate difference between 2 or more dates in the same Cell ? Dates are in the format shown below (Always seperated by a comma): Cell A1 = 29Jan2009, 31Jan2009, 14Feb2009, 27Feb2009, 31Mar2009. In the above case there are only 5 sets of dates, in some cases there...