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