
Hi! I am importing two cells from a different excel spreadsheet into my own, and wish to calculate the difference between two dates... Example I'm importing this value to C9: 10/04/2014  23:00 And I'm importing this value to D9: 11/01/2014  22:59 I would like to take D9 & C9 and have it...

I have a database containing the age of people. The values are integers, so for example 25, 88, 56 etc. I need to estimate a date of birth for each person. I have decided to use 1st January of the year of birth as the date of birth and so need to get from, for example, an age of 88 to a date of birth...

Hello everyone. Using Excel 2010 I need to write a formula that states If colum D has a date, then what is the date in 14 days. Simple date plus 14 =D4+14. However, I don't want a response if there is no date in column D. Can anyone help please? Thank you! Misti

Is there anyone there that can assist with an elegant and accurate way to calculate the age of a person using the current date stored in one cell and a person’s birthdate in another cell? I am trying to calculate and display a person’s age in years only as of the date entered into the Current...

Confession time . I just got bit on this one. I use the following array formula to count the number of pay periods in a calendar month. {=SUM(IF(MONTH(PayPeriods)=1,1,0))} This example is for January. The range PayPeriods is 27 cells. The 27th cell is due to the once a decade or so occurrence where you...

Another way of putting it, if your DOB is in cell A1 then =DATE(YEAR(A1)+60,MONTH(A1),DAY(A1))

I have spreadsheets which have dates listed in Column A with other data in subsequent columns. There may be multiples (even hundreds) of one date listed (see example below). 5May08 6May08 7May08 7May08 7May08 8May08 There are also missing dates (e.g. 1May08 to 4May08). Ultimately, I need...

Recently, someone at my firm created a DAYS360 formula " =DAYS360(A19,$D$11,FALSE)" and used the dates of Feb 28, 2002  Feb 28, 2006 to calculate interest. For some reason, for the first year of 2002 it should return 1,440 days but is returning 1,438 days. I changed the "FALSE" to...

=IF((AND(L16="H",H16>0)),(J16H16+K16),IF((OR(L16="H",H16=0)),(H16+J16+K16),(IF(L16="D",(I16+DATE_TEXT(K16)),IF(L16="C",(H16+J16+K16)))))) When the user selects "d" in L16, the system needs to add a date such as 4/24/2007 in cell I16 and a number of...

For completeness and to close the thread, I suspect the OP had noticed that a time in excel is a decimal of a day (a day being 1), so 12 noon is .5 and so on. So to multiply times by hourly rate for example, you have to multiply the hours by 24 to get days, so, if you have a time of 8 hours at £20 per...