formula for month(s) prior to actual

B

braadi

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),"MMMYYYY")
 
P

Peo Sjoblom

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
 
B

Bob Phillips

=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)
 
R

Roger Govier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Percentage of month passed formula 1
Mapping strings to integers 6
formula for month that is prior to actual 6
Month days over a time period 5
Date / month / year 1
Formula for calculating target hours against actual hours 12
Search closest day in the past from today 2
How to Create an S-Curve from Custom Field? 0

Top