-
[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...