Difference in dates
Using Excel 2007, I would like to see the difference between 2 dates.
1 column is formatted as: month/yr. I would like to use the (now or today) command in the second column. When I open up the spreadsheet, I want the difference between the 2 columns to reflect today's date. Thanks |
Difference in dates
Hi Charles,
Assuming the first date is written in Cell A1, then Write inside cell B1 the following formula: =Today()-A1 if the formula's result is showing as a date, then format that cell as a number. ------ http://www.free-training-tutorial.com "Charles Eaves" wrote: Using Excel 2007, I would like to see the difference between 2 dates. 1 column is formatted as: month/yr. I would like to use the (now or today) command in the second column. When I open up the spreadsheet, I want the difference between the 2 columns to reflect today's date. Thanks |
Difference in dates
Thanks
"Jack Gopher" wrote in message ... Hi Charles, Assuming the first date is written in Cell A1, then Write inside cell B1 the following formula: =Today()-A1 if the formula's result is showing as a date, then format that cell as a number. ------ http://www.free-training-tutorial.com "Charles Eaves" wrote: Using Excel 2007, I would like to see the difference between 2 dates. 1 column is formatted as: month/yr. I would like to use the (now or today) command in the second column. When I open up the spreadsheet, I want the difference between the 2 columns to reflect today's date. Thanks |
Difference in dates
That works fine but how do show the result as: month/yr.
I tried what you suggested and I get a number of days (8) for the result. I think I used April 29,2009: formatted as 4/09. I right clicked on the (=Today()-A1) cell and tied to format for m/yr but no luck. Thanks "Charles Eaves" wrote in message ... Thanks "Jack Gopher" wrote in message ... Hi Charles, Assuming the first date is written in Cell A1, then Write inside cell B1 the following formula: =Today()-A1 if the formula's result is showing as a date, then format that cell as a number. ------ http://www.free-training-tutorial.com "Charles Eaves" wrote: Using Excel 2007, I would like to see the difference between 2 dates. 1 column is formatted as: month/yr. I would like to use the (now or today) command in the second column. When I open up the spreadsheet, I want the difference between the 2 columns to reflect today's date. Thanks |
Difference in dates
Charles
Try Custom Format: yy "years"" mm "months" dd "days" or Custom Format: mm"/"yy "Charles Eaves" wrote: That works fine but how do show the result as: month/yr. I tried what you suggested and I get a number of days (8) for the result. I think I used April 29,2009: formatted as 4/09. I right clicked on the (=Today()-A1) cell and tied to format for m/yr but no luck. Thanks "Charles Eaves" wrote in message ... Thanks "Jack Gopher" wrote in message ... Hi Charles, Assuming the first date is written in Cell A1, then Write inside cell B1 the following formula: =Today()-A1 if the formula's result is showing as a date, then format that cell as a number. ------ http://www.free-training-tutorial.com "Charles Eaves" wrote: Using Excel 2007, I would like to see the difference between 2 dates. 1 column is formatted as: month/yr. I would like to use the (now or today) command in the second column. When I open up the spreadsheet, I want the difference between the 2 columns to reflect today's date. Thanks |
All times are GMT +1. The time now is 06:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com