Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) | |||
Default Dates | Excel Discussion (Misc queries) | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
due dates | New Users to Excel |