I'm trying to create a macro to sort and clean up data I import into excel that includes dates, amounts, and text fields. When I record the macro, I sort the date column from oldest to newest, but w...
DATE(2010,1,1) and returns 2010-1-1 (1/1/2010) Step 2 - Build an array of recurring dates EDATE(TRANSPOSE(Table1[Date]), (ROW($1:$1000)-1)*TRANSPOSE(Table1[Recurring n-th month])) I can't show all dates here, there are two many. 1000 recurring dates for each date. I hav...
Question: I am trying to create an excel spreadsheet that has a date range. Example: Cell A1 1/4/2009-1/10/2009 Cell B1 1/11/2009-1/17/2009 Cell C1 1/18/20
Also, I need to calculate the age of a person and I use =datedif(xx,xx,"y"). But, again,. the calculation won't work for any date prior to 1900. Hello!
Hi,For the District Analysis tab on the attached spreadsheet, I am trying to sort the numerical columns lowest to highest or vice versa but they are not...