Matching given month to a column containing the same month

[xlmaz]

Hi Guys,

Hope all doing great. I need a quick help. I am doing a Business case. In the assumption sheet I will be entering the launch month (Eg Mar-20). Then in the working sheet my revenues and costs should start from this launch month, if I change the launch month the variables should also should change. How can we do this is excel? Thanks..

 

[Matty]

Hi, and welcome to MrExcel.

That doesn't give us a lot to go on. Could you provide a small mock up and post it? You can use one of the HTML makers here to do that:

https://onedrive.live.com/?id=8CFFDEC0CE27E813!189&cid=8CFFDEC0CE27E813

Matty

 

[levy77]

Hi xlmaz,

Have row one in the working sheet equal to the launch month day. The row below that enter the formula =DATE(YEAR(A1),MONTH(A1),DAY(A1)+1) and drag it down. Whenever you update the launch cell it will auto update all the days on the working page.

Cheers