Showing related tags and posts accross the entire site.
-
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...