Microsoft Office Forums - View Single Post - Formula to use a date to calculate an amount $.

Thread: Formula to use a date to calculate an amount $.

View Single Post

Old

04-23-2016, 06:40 PM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

Change all of dates beginning in S3 to 1/1/2015, U3 to 2/1/2015, and so on

Now in S4

=SUMPRODUCT(--(MONTH($I$11:$I$40)&YEAR($I$11:$I$40)=TEXT(S3,"mmy yyy")),$J$11:$J$40)

copy to U4, W4 etc

Reply With Quote