Results 1 to 3 of 3

getting total from column if todays date is equal to or greater than date column

Threaded View

  1. #1
    Registered User
    Join Date
    07-08-2012
    Location
    uk
    MS-Off Ver
    Excel 2010
    Posts
    2

    Question getting total from column if todays date is equal to or greater than date column

    Hi All,

    I need some help with getting a total from a column (new customers) only if todays date is equal to or greater than my date column (w/e sunday)

    in the attached jpeg i have put formula in b1, but this is only for 1 date as i get errors what ever i try to get this to work :/

    if this was working correctly then b1 should be showing 3 and on the 15th dec it should be 6

    is there a way of doing this?
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Auto Fill Todays Date In Column K in Last Value Found in Column A
    By trevor2524 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-18-2013, 02:42 PM
  2. If hire date (column D) is greater than revision date (column F) then delete row
    By bruinsrme in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-14-2013, 07:25 PM
  3. [SOLVED] Search column for a number, then add the todays date at the next column
    By spider2809 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-11-2012, 12:24 PM
  4. Replies: 5
    Last Post: 10-14-2010, 01:06 AM
  5. [SOLVED] Create new column with todays date and jump to column
    By ping8781 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-19-2010, 06:53 AM

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