+ Reply to Thread
Results 1 to 5 of 5

formula for month(s) prior to actual

  1. #1
    braadi
    Guest

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



  2. #2
    Peo Sjoblom
    Guest

    Re: 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" <braadi@discussions.microsoft.com> wrote in message
    news:DE783A1C-7E8C-432E-AA75-2B1A1D515B24@microsoft.com...
    > 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")
    >
    >




  3. #3
    Bob Phillips
    Guest

    Re: 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" <braadi@discussions.microsoft.com> wrote in message
    news:DE783A1C-7E8C-432E-AA75-2B1A1D515B24@microsoft.com...
    > 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")
    >
    >




  4. #4
    Roger Govier
    Guest

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


  5. #5
    braadi
    Guest

    Re: 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" <braadi@discussions.microsoft.com> wrote in message
    > news:DE783A1C-7E8C-432E-AA75-2B1A1D515B24@microsoft.com...
    > > 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")
    > >
    > >

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1