Trouble Changing date Formats

Simonc64

Board Regular
Joined
Feb 15, 2007
Messages
184
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

Well-known Member
Joined
Jul 14, 2010
Messages
1,283
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:
Code:
=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().
 

Forum statistics

Threads
1,082,603
Messages
5,366,578
Members
400,904
Latest member
ndaines meriabi

Some videos you may like

This Week's Hot Topics

Top