date arithmetic

Hi I'm having problems with the following formula: <tbody> A B C Date Opened Date Closed Total days to closeout 26/07/2013 13/08/2013 18 26/07/2013 19/08/2013 24 31/07/2013 -41486 01/08/2013 -41487 </tbody> I want to copy the following formula in Column C all the way...

Hello and thank you so much for being here! I am constantly coming to Mr Excel to learn new techniques, but this one has me stumped. I am trying to have the oldest date listed in column F (Other than the blank ones), for rows where column K = 1 and column G = TRUE.........I always get the date...

Sometimes there are 28/29/30/31 days in a month in a year, right?! What's the simplest ways to meet the following task? 1. The Year or/and month can be change 2. Once the date is change the Week of days in different(Mon, Tue...) would also be changed correctly 3. Show correctly if there are...

I am using EXCEL 2010. Problem: I am seeking to develop a formula that allows me to enter a starting or base date (example: January 1, 1970), a distinct # of days (an integer), and gives me as a result the month/day/year that the resulting date falls on. example: starting date : 1/1/1970 #...

Hi all I am hoping for some help in incrementing through dates using VBA. I am using VBA to fire queries at a database bringing back information by Month in a recordset. The servers at work are struggling and are timing out due to the size of the record set being returned (one of the RS...

Hi, I am a nurse at a prison and I have close to 1200 patients that I have to keep up with different medical information. None of our records are electronic so needless to say I am trying to create a "manual" E-MAR..that being said, I am administering TB shots and then entering the date of the...

Hi I own a jobs board, I can export job application data to excel I would like to be able to turn this data into a simple graph that shows the number of job applications we have each day. I can work it out manually but I need a formula that adds up the applications in given day. The data...

I have a table that I am storing into an array. I have an array FDate where I store a date and another array FTime where I store times. FDate is formatted as m/dd/yyyy Hh:Mm: Ss Ftime is formatted as Hh:Mm:Ss I know in excel that you can add and subtract dates and times. How do you...

i have three dynamic columns that have dates in them. there are dates in column E, I, and J starting at row 5 and going down X number of rows...X because i have an external feed which updates and it results in column E, I and J going down different numbers of rows every time it updates....but...

Hello, I am struggling with date/time calculation in VBA. 1. Can I add/subtract dates as in the next example: Dim vStart As Date, vEnd As Date, vHours As Date dim vHours1 as integer vStart="20:00" vEnd = "23:00" vHours=vEnd-vStart vHours gives me "03:00:00"...

Hi all, I have a worksheet that i copy production data in. Each production process is in a row and in the columns i have the production of each day of the week and some derivate functions as 'in stock' etc. The production is for each calendar date. The data are in a sheet that i get every...

I am using excel 2007 and WinXP. I am creating a chemical database including MSDS (material safety data sheets) which need to be no more than 5years old. I am trying to write a formula such that a year can be entered (e.g. 2007) and in the next cell will be 'yes' or 'no' depending on the answer...

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 need help with a formula. On D2 I have "=today()-E2" which counts the date between today's date and the date entered on E2. But once a date is enter on F2, I need D2 to return the value of "E2-F2" instead of "=today()-B2". Is this even possible?

Hi guys. ive got a complicated one (i think) if i have a hotel and the room rate is different for each calendar date bracket eg: 01 august - 15 august = £15 16 august - 30 august = £25 Is there a way i can get excel to calulate the price for the customers stay. for example if they were...

I inherited about 1300 workbooks in a single folder that: I need to update a cell value on 1 worksheet from one variable date to the same date 1 year later. # of worksheets may vary - there might be 1 worksheet before the targeted tab I could exist with a macro that merely updates the value...

A certain bank (OK, Chase) formats its downloadable .csv file line item dates as text, like this: 1) "20090309120000[0:GMT]" This example (1) translates as 2009 (year), 03 (month), 09 (day), 12:00 (hours:minutes), 00 (seconds) [0:GMT] (Greenwich Mean Time). Using "Text to Columns", this...

If I have the date 01-09-09 in cell A1, is there a formula that can produce the day before into a different cell? (01-08-09) And will this work for the beginning/end of each month? For example if the date is 02-01-09, will the formula come up with 01-31-09? Thanks!

I am running Microsoft Access 2007 SP1. I have a table (called CAL_INFO) and form (CAL_INFO_FORM) setup in a simple Access database that tracks equipment in my company. One of the fields in the form has a date that the equipment was last checked for accuracy. I call this field "DATE_LAST_CAL"...

We have a client that has to total the number of days that people received medical care (for insurance purposes). BUT...they can't count duplicate days. Some of the dates show a range of days, others only one day. They've asked for my help. (We're actually a computer services firm, but I'm...