Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to count the last 30 days of activities
Have several columns with details
Column A5 and down=Date Column B5 and down=Activity Column C5 and down=Type of transportation I now have 250 rows with activities from today and back in time. My question is how can I have a variable in A1 where I can ask the last X days activities. I will choose in A1 how many days back in time the number of activities done. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to count the last 30 days of activities
Hi MSSailor,
Have several columns with details Column A5 and down=Date Column B5 and down=Activity Column C5 and down=Type of transportation I now have 250 rows with activities from today and back in time. My question is how can I have a variable in A1 where I can ask the last X days activities. I will choose in A1 how many days back in time the number of activities done. Put this formula in cell D5 =INT(NOW())-A5<=$A$1 This returns TRUE if the date in A5 is A1 days or less than today. Filter for column D is TRUE Ed Ferrero |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to count the last 30 days of activities
You wrote to put it in D5=INT(NOW())-A5<=$A$1
Can the value in D5 be the value that I can fill in. If D15=30 ; is calculating numbers of activities 30 days back in time starting from today If D15=15 ; is calculating numbers of activities 30 days back in time starting from today Column A Column B DATE ACTIVITY A5=date 1 B5=Running A6=date 2 B6=Jogging A7=date 3 B7=Diving An A50 date 46 B46=Skiing "Ed Ferrero" wrote: Hi MSSailor, Have several columns with details Column A5 and down=Date Column B5 and down=Activity Column C5 and down=Type of transportation I now have 250 rows with activities from today and back in time. My question is how can I have a variable in A1 where I can ask the last X days activities. I will choose in A1 how many days back in time the number of activities done. Put this formula in cell D5 =INT(NOW())-A5<=$A$1 This returns TRUE if the date in A5 is A1 days or less than today. Filter for column D is TRUE Ed Ferrero |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to count the last 30 days of activities
Is there any advantage in using INT(NOW()) instead of TODAY() ?
-- David Biddulph "Ed Ferrero" wrote in message ... Hi MSSailor, Have several columns with details Column A5 and down=Date Column B5 and down=Activity Column C5 and down=Type of transportation I now have 250 rows with activities from today and back in time. My question is how can I have a variable in A1 where I can ask the last X days activities. I will choose in A1 how many days back in time the number of activities done. Put this formula in cell D5 =INT(NOW())-A5<=$A$1 This returns TRUE if the date in A5 is A1 days or less than today. Filter for column D is TRUE Ed Ferrero |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to count the last 30 days of activities
David Biddulph wrote,
Is there any advantage in using INT(NOW()) instead of TODAY() ? No, old habit :) Ed Ferrero www.edferrero.com |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to count the last 30 days of activities
Hi MSSailor,
You wrote to put it in D5=INT(NOW())-A5<=$A$1 Can the value in D5 be the value that I can fill in. If D15=30 ; is calculating numbers of activities 30 days back in time starting from today If D15=15 ; is calculating numbers of activities 30 days back in time starting from today Column A Column B DATE ACTIVITY A5=date 1 B5=Running A6=date 2 B6=Jogging A7=date 3 B7=Diving An A50 date 46 B46=Skiing I mean put =INT(NOW())-A5<=$A$1 in cell D5 Then D5 will evaluate to TRUE or FALSE depending on the values in cells A1 and A5 If A1 = 30 (meaning you want the last 30 days activities) And A5 = 12-3-2009 Then D5 will show TRUE If A5 = 12-1-2009 Then D5 will show FALSE Copy cell D5 down as far as you need to Then use autofilter to show all the rows where column D = TRUE As David Biddulph pointed out, you can simplify the formula to =TODAY()-A5<=$A$1 Ed Ferrero www.edferrero.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Days more than 180 days prior to today | Excel Worksheet Functions | |||
When word says Install I want it count the days for 3 days w.o wee | Excel Worksheet Functions | |||
count days | Excel Discussion (Misc queries) | |||
COUNT how many ROWS ago out of 10 days that the highest high in 10 days was made | Excel Worksheet Functions | |||
count days | New Users to Excel |