Steve Eckerman

asked on

# Excel Formula Help

Can somebody break down this formula for me and explain it part by part? I already got some help with it and understand what the formula is doing, but I want to know what part of it makes the data move from one column to the next depending on what the release date is.

There is also a spread sheet attached, including sample data, which should help you explain it.

=IF(DATEDIF(EOMONTH($E$2,-1)+1,EOMONTH($E2,-1)+1,"m")=COLUMNS($I$1:I$1)-1,$F2*$H2,"")

Thanks

Sample.xls

There is also a spread sheet attached, including sample data, which should help you explain it.

=IF(DATEDIF(EOMONTH($E$2,-

Thanks

Sample.xls

ASKER CERTIFIED SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**ASKER

Ok, I understand now. =) Thanks guys.

ASKER