Hi All,
I was wondering if anyone could help me out here with writing a formula. I know a little more than the basics of excel, but when it comes to writing formula im not to good. I get this weekly excel report at work for all of our computers that are “surplus” ..there are like 10 different models ranging from regular devices to engineering standard devices. The devices have a “life cycle” 3 years 1 month for engineering, and 3 years 9 months for standard devices.
The excel sheet I get is broken down into 6 columns (device ID, status, First Install Date, Model, Description) ..I add another column right after the “first install date” column called “end of life cycle”
What I’m trying to do is write a formula that will select the whole column of “first install date” and output each cell in that column into the new column that I made into the corresponding cells in that.
For Ex:
First install date: (C Column) End of Life Cycle Date: (D Column)
1/2/2007
2/5/2008
2/6/2010
8/20/2009
11/15/2012
4/30/2011
The formula I wrote:
=DATEDIF(C2:C125,TODAY(),"y")&" years "&DATEDIF(C2:C125,TODAY(),"ym")&" months "&DATEDIF(C2:C125,TODAY(),"md")&" days"
Rather than doing it cell by cell(there's 125 dates in C) The formula works for cell after cell, but i want to do it all at once. When I try to highlight the “d” column, and enter the formula it outputs only one cell. I want each cell from “C” to output to “D” with correct date difference between the “first install date” and “today’s date”
I hope you all understand what im trying to do. Not even sure if what im looking for is possible, but any help would be appreciated.
Thank You.
Bookmarks