Results 1 to 11 of 11

1 day less than today’s date put a 1 in cell B2, etc

Threaded View

Buddy7 1 day less than today’s date... 10-05-2009, 12:10 PM
JBeaucaire Re: If the date is 10-05-2009, 12:21 PM
JBeaucaire Re: If the date is 10-05-2009, 01:10 PM
royUK Re: If the date is 10-05-2009, 01:20 PM
Buddy7 Re: If the date is 10-05-2009, 02:44 PM
Buddy7 Re: 1 day less than today’s... 10-05-2009, 02:53 PM
Cheeky Charlie Re: 1 day less than today’s... 10-05-2009, 03:11 PM
JBeaucaire Re: 1 day less than today’s... 10-05-2009, 06:19 PM
Buddy7 Re: 1 day less than today’s... 10-19-2009, 04:58 PM
Cheeky Charlie Re: 1 day less than today’s... 10-20-2009, 05:14 AM
Buddy7 Re: 1 day less than today’s... 10-20-2009, 10:59 AM
  1. #1
    Registered User
    Join Date
    05-04-2009
    Location
    San Diego, California
    MS-Off Ver
    Excel 2003
    Posts
    43

    1 day less than today’s date put a 1 in cell B2, etc

    Sub DateCounting()
    
    Sheets("Sheet3").Activate
    
    Set newsht = Sheets.Add(after:=Sheets(Sheets.Count))
    newsht.Name = "Data"
    If the date in column J, Sheet3
    -is1 day less than today’s date put a 1 in cell B2, sheet “Data”
    -is 2 days less than today’s date put a 1 in cell B3, sheet “Data”
    -is 3 days less than today’s date put a 1 in cell B4, sheet “Data”
    -is 4 days less than today’s date put a 1 in cell B5, sheet “Data”
    -is 5 days less than today’s date put a 1 in cell B6, sheet “Data”
    -is 6 days less than today’s date put a 1 in cell B7, sheet “Data”
    -is 7 days less than today’s date put a 1 in cell B8, sheet “Data”
    -is between 8-31 days less than today’s date put a 1 in cell B9, sheet “Data”

    'Loop for every row with contents so that totals appear in B2,B3,B4,etc.
    
    Application.DisplayAlerts = False
    Sheets("Sheet3").Delete
    Application.DisplayAlerts = True
    
    End Sub
    If you can help, Thank you. Above is what I am trying to do. Can you help me translate what I wrote into code? Every row in column J with a date that is 1 day less than today's date I want to add in cell B2 of sheet "Data", every row that is 2 days less than today's date I want to add in cell B3 sheet "Data," and so on.
    Last edited by Buddy7; 10-19-2009 at 04:58 PM. Reason: SOLVED

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