|
Calculated Dates In a Heading
I have a heading on a worksheet that shows the spread of work on that
sheet, which is always 13 months. So the current heading reads "Average Of data between Sept 2004 and Sept 2005" I believe i can put this in the form of a formula where Sept 2005 will always be the current month -1 and the Sept 2004 date will always be the current month -14. Does any one know the formula that would achieve this please. |
Calculated Dates In a Heading
="Average Of data between "&TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())-1,1),"mmm
yyyy")&" and "&TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())-13,1),"mmm yyyy") -- HTH RP (remove nothere from the email address if mailing direct) "Box666" wrote in message ups.com... I have a heading on a worksheet that shows the spread of work on that sheet, which is always 13 months. So the current heading reads "Average Of data between Sept 2004 and Sept 2005" I believe i can put this in the form of a formula where Sept 2005 will always be the current month -1 and the Sept 2004 date will always be the current month -14. Does any one know the formula that would achieve this please. |
| All times are GMT +1. The time now is 07:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com