+ Reply to Thread
Results 1 to 4 of 4

Date Range Macro?

  1. #1
    Registered User
    Join Date
    10-29-2008
    Location
    San Jose
    Posts
    1

    Date Range Macro?

    I'm having trouble creating a macro. Here is what I need it to do. If the date on an item (listed in column E10) is less than 30 days from today, then put it in column H10. if not, do nothing. Here is the formula I made, but it does not work. Any tips?

    =IF(10/28/08-E10<30,H10,`)


  2. #2
    Forum Contributor
    Join Date
    12-19-2006
    Posts
    113
    Hi Audreya,

    I.m not sure about what you want...
    Try use that formula in the cell H10
    Please Login or Register  to view this content.

  3. #3
    Valued Forum Contributor rwgrietveld's Avatar
    Join Date
    09-02-2008
    Location
    Netherlands
    MS-Off Ver
    XL 2007 / XL 2010
    Posts
    1,671

    re: Date Range Macro?

    Please Login or Register  to view this content.
    Looking for great solutions but hate waiting?
    Seach this Forum through Google

    www.Google.com
    (e.g. +multiple +IF site:excelforum.com/excel-general/ )

    www.Google.com
    (e.g. +fill +combobox site:excelforum.com/excel-programming/ )

    Ave,
    Ricardo

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Where does the macro come into this?
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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