Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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") |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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") |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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") |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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") |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
How to solve a formula so that it returns actual answer if negati. | Excel Discussion (Misc queries) |