Results 1 to 11 of 11

Help with dates

Threaded View

  1. #1
    Registered User
    Join Date
    08-13-2012
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    19

    Help with dates

    Hello everybody.

    I need a help related to formulas with dates.

    I have a start date (10/02/2014) and an end date (30/10/2014) when compared with the date "eg: Jan / 14 must show" 0 "on the worksheet, where to Feb/14 should show "1" until Oct/2014.

    Ex:

    Start date End date jan/14 fev/14 mar/14 abr/14 mai/14 jun/14 jul/14 ago/14 set/14 out/14 nov/14 dez/14 jan/15 fev/15 mar/15
    10/02/2014 30/10/2014 0 1 1 1 1 1 1 1 1 1 0 0 0 0 0
    06/12/2013 30/05/2014 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0
    02/10/2013 30/03/2014 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0

    Thanks.
    Last edited by hbender; 02-24-2015 at 02:54 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Check dates in range either same dates or different dates by formula
    By breadwinner in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-12-2013, 07:42 AM
  2. Replies: 6
    Last Post: 03-11-2013, 06:11 PM
  3. [SOLVED] Array of dates when tested shows no dates ......but there are dates
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-29-2012, 12:45 PM
  4. [SOLVED] Highlight Group of Dates if Dates Match List of other Dates
    By martinpgibson in forum Excel General
    Replies: 5
    Last Post: 10-24-2012, 08:14 PM
  5. [SOLVED] Auto filling dates based on previously entered dates and averaging numbers if dates equal
    By grambograham in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-11-2012, 03:21 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