• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

<solved> excel fill in number based on month + duration

H

hford

New Member
Hi All,

I have a problem on fill in the duration automatically by search on the month + duration as per the example,

the table OUTPUT desired is the one that i want, please help me, thank you

ps : adding helper number or column on top of the month from jan - dec is also fine ( i was thinking this way before but couldnt solve it :p )
 

Attachments

  • sample.xlsx
    10.9 KB · Views: 5
hi for everyone that wants to know the answer, fill below in the sample file

=IF(AND(E$3>=$C4,E$3<=EOMONTH($C4,$D4-1)),$B4,"")
 
You must log in or register to reply here.
Back
Top