Trouble Changing date Formats

[Simonc64]

Good Morning All

I have a datasheet that looks at health interventions in an organisation.

A data feed I receive populates the datasheet with the dates on which these interventions happen and I calculate the next due date of the intervention for an individual - nothing complicated, quite simply =IF(A2>0,A2+364,"-")

To be helpful and offset any unwanted user queries Ive added in some text, again nothing complicated, =IF(A2>0,CONCATENATE("Due by"&" "&TEXT((A2+364),"DD/MM/YYYY")),"-")

All of which works really well and the users are happy; however I have users now who like the specific "DD/MM/YYYY" output but others who prefer a more general "MM/YYYY". Easily resolved or so I thought - i'll just write a macro to change the "DD/MM/YYYY" to "MM/YYYY" in my formulae, but no! Something, and I presume its to do with date formats, is stopping this from happening. the formulas are changing but the output isn't

If anyone has any solutions id be very grateful!

Thanks

Simon

 

[bobsan42]

Is formula calculation automatic? Just in case check the far right on the Formulas tab.
I can't really imagine what can cause this behavior.

or try to extract the month and the year separately:

=IF(A2>0,CONCATENATE("Due by ",TEXT(MONTH(A2+364),"00"),"/",YEAR((A2+364))),"-")

BTW, you don't need to use & when you use concatenate().