Formulas to Include Month Dependence

[Tech56]

Hello,

On my Recurring Log sheet there are date formulas in column B. Can these be adjusted to include column K for month dependence? Basically I don't want to have a date for B16 when October comes around or any other month except September which shows in K16.

Thank you

 

[herofox]

hi,this which you mean

 

[Tech56]

No the month that has orange fill is the only one for now that occurs once per year. All the others occur every month.

Thanks

 

[bosco_yip]

Maybe,

In "Recurring Log" sheet B4, formula copied down :

=IF(J4<>0,DATE(YEAR(TODAY()),MONTH(IF(ISNUMBER(0+([@Month]&1)),0+([@Month]&1),TODAY())),J4),"")

Regards

 

[Tech56]

Hi I am getting 03/03/2019 for my first result. It should be 09/03/2019 thanks.

 

[bosco_yip]

Hi I am getting 03/03/2019 for my first result. It should be 09/03/2019 thanks.

My copy of file work fine in B4, and show 09/03/2019 with my posted formula.

Please ensure you are copied the formula in correctly.

Regards

 

[Tech56]

I think I did correctly. Can you take a look please?

 

[bosco_yip]

You make changing to your original post #.1 and post #.7 Column K range layout, of course the formula doesn't work.

So, it is your problem, without knowing what is your final design, it is unable to give you further help

Regards

 

[Tech56]

Okay fine I will figure this out somehow.

 

[Tech56]

I was able to come up with one possible way thanks.