+ Reply to Thread
Results 1 to 11 of 11

month formula to know

Hybrid View

  1. #1
    Banned User!
    Join Date
    10-29-2012
    Location
    Europe
    MS-Off Ver
    2013, 2016
    Posts
    318

    Re: month formula to know

    In E4 I put the formula = IF (AND (MONTH ($ A4) = MONTH (S $ 3), YEAR ($ A4) = YEAR (S $ 3)), $ B4, "") then "dragged" to the right and down and in D4 I put the formula = IF (AND (MONTH ($ A4) <= MONTH (S $ 3), YEAR ($ A4) <= YEAR (S $ 3)), $ B4, "") then "dragged" down.

    I change the name of month with real date.
    See the attachment.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Counting & summing formula (until last month,this month,until this month..
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-12-2014, 01:14 PM
  2. Month over Month formula to show increase or decrease in rankings for SEO
    By lindsbay in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-12-2014, 03:03 AM
  3. Formula for average duration for each month based on the ending month
    By bobby769 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-21-2013, 11:18 AM
  4. Replies: 5
    Last Post: 10-04-2012, 07:06 AM
  5. [SOLVED] Formula to Relist Ranges by Month Opening instead of Calendar Month
    By investmentbanker in forum Excel General
    Replies: 3
    Last Post: 05-18-2012, 01:33 PM

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