Is there an automated way to have Excel find dates from a date that is specified only to the last day that year which is not specified? For instance, I bought a stock on February 1, 2002. I then bought more stock that year, and some in 2003. However, I only want to see any stock I bought between Feb 2, 2002 and Dec 31, 2002. However, the Year End date is not hard coded anywhere in my database. I would go in and manually enter the end dates, but I have 423000 rows.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Calculating dates
- Thread starter sirace
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question