formula for month(s) prior to actual
yesterday i asked for a formula that would give month and year prior to
actual based on excel time and date, and the answer i received worked. i also need the formula(s) for months 2 and 3 prior to actual to provide data in a 3 month trend (i.e. a report generated in december would provide data for october and september as well). i can't figure out how to tweak the formula from yesterday to work. =TEXT(DATE(YEAR(TODAY()),MONTH(TODAY()),0),"MMMYYY Y") |
formula for month(s) prior to actual
Just subtract from the month
=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())-1,0),"MMMYYYY") will give you Oct2005 =TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())-2,0),"MMMYYYY") Sep2005 and so on -- Regards, Peo Sjoblom "braadi" wrote in message ... yesterday i asked for a formula that would give month and year prior to actual based on excel time and date, and the answer i received worked. i also need the formula(s) for months 2 and 3 prior to actual to provide data in a 3 month trend (i.e. a report generated in december would provide data for october and september as well). i can't figure out how to tweak the formula from yesterday to work. =TEXT(DATE(YEAR(TODAY()),MONTH(TODAY()),0),"MMMYYY Y") |
formula for month(s) prior to actual
=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())-1,0),"MMMYYYY")
=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())-2,0),"MMMYYYY") -- HTH RP (remove nothere from the email address if mailing direct) "braadi" wrote in message ... yesterday i asked for a formula that would give month and year prior to actual based on excel time and date, and the answer i received worked. i also need the formula(s) for months 2 and 3 prior to actual to provide data in a 3 month trend (i.e. a report generated in december would provide data for october and september as well). i can't figure out how to tweak the formula from yesterday to work. =TEXT(DATE(YEAR(TODAY()),MONTH(TODAY()),0),"MMMYYY Y") |
formula for month(s) prior to actual
Hi
Try =TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())-n,1),"MMMYYYY") Change n to 1, 2 and 3 respectively to get the previous months -1, -2, -3 Regards Roger Govier braadi wrote: yesterday i asked for a formula that would give month and year prior to actual based on excel time and date, and the answer i received worked. i also need the formula(s) for months 2 and 3 prior to actual to provide data in a 3 month trend (i.e. a report generated in december would provide data for october and september as well). i can't figure out how to tweak the formula from yesterday to work. =TEXT(DATE(YEAR(TODAY()),MONTH(TODAY()),0),"MMMYYY Y") |
formula for month(s) prior to actual
right on. i love this discussion board. thank you so much.
"Peo Sjoblom" wrote: Just subtract from the month =TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())-1,0),"MMMYYYY") will give you Oct2005 =TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())-2,0),"MMMYYYY") Sep2005 and so on -- Regards, Peo Sjoblom "braadi" wrote in message ... yesterday i asked for a formula that would give month and year prior to actual based on excel time and date, and the answer i received worked. i also need the formula(s) for months 2 and 3 prior to actual to provide data in a 3 month trend (i.e. a report generated in december would provide data for october and september as well). i can't figure out how to tweak the formula from yesterday to work. =TEXT(DATE(YEAR(TODAY()),MONTH(TODAY()),0),"MMMYYY Y") |
All times are GMT +1. The time now is 06:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com