-
My sincerest appreciation to all of you in this user group who put the time into helping others. I retrieve a list of events from a database and want to turn that into a specific sort of timeline in Excel. But the pivoting and tranformation process is beyond me. The events relate to people and each has...
-
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...
-
[quote user="steve2010"] ... I need to use the time period in various formulas. Thanks in advance - steve [/quote] Steve Seeing the quote above, i'm not sure you'd want to would you? Time is just a decimal representation of a day (whole number) measured from 1st January 1900, so 12...
-
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). 5-May-08 6-May-08 7-May-08 7-May-08 7-May-08 8-May-08 There are also missing dates (e.g. 1-May-08 to 4-May-08). 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)),(J16-H16+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...