|
|
#8
06-29-2016, 09:04 PM
|
|||
|
|||
I am in doubt if you are interested in a solution from me, but if you are you might want to take a look at the attached.
You wrote: In other word the date of 11/18/2016 in column J would pick out the cost that goes with at date and would put the totals of that in AA7 As far as I can see the dates you mention are in column I, not in column J and they are not from 2016 but from 2015 while the date in AA6 is in year 2016. I don't know if you just want to check for month and not for year. I have (in the formula in AA7) assumed you want to check for both year and month and accordingly I have temporarily changed the year in AA6 to 2015. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Need help with using traffic lights in one cell based on date value in a different cell
|
wmedjaxnjr | Excel | 1 | 04-09-2016 04:22 PM |
|
Cost resource not taken in real cost
|
pascalbidouille | Project | 1 | 08-21-2015 01:25 PM |
| calculate date if date entered in cell, do nothing if blank | ConfuddledOne | Excel | 3 | 11-07-2014 09:37 AM |
| Make table cell active add date count date | MelHerndon | Word VBA | 3 | 01-21-2013 04:23 PM |
| How can I make a cell color RED under the Today's date cell? | Learner7 | Excel | 2 | 07-08-2010 12:52 AM |
Windows 10 
Office 2016
Threaded Mode