Search results for query: *

Thank you Skip, yes you are right to assume that I know there is a difference between the stored and displayed values. with my default settings, this number 44752 when displayed as a date becomes 10.07.2022 - 10th of July under the European (German) format. when this data is treated within...

it is all good as it is. so you might understand why it is already solved with my last version: it is MY databank in MY excel file that I fill with registers about the topics I need to work on. among the data there are several date trackers for each register. since I gather the data from...

Hello Paul, right with this remark I think I can say the same about you removing the D/M swap won't work here due to all the reasons I have explained. in fact the results were all wrong until I remembered to include the swap in this formula too. I am not sure there will be any easy trick to...

thanks Andy, I do programm in VBA too, and I did some testing to fill purely through macros my different forms and documents that I need, it took way tooooooo lonnnnnng to execute. in the end merging is the fastest solution in the state of how the computer and the data are stored and...

ohhh got you now, I am maybe so slow right now cause I am so tired sorry, I can then still simplify a bit further if I test this condition inside the formula where I need it for the MOD calculations KW number for the current date (should be directly applicable to the different date document...

thank you very much for the information Paul, "en-dash (–) instead of a minus sign - " - this happened as I worked in Word on the formula, it replaces the sign in a text.. just testing your proposal, [highlight #FCAF3E]{=MOD({DATE \@ yy}[highlight #FCE94F],[/highlight]4)=0}[/highlight]...

Complementing thread68-957685 Hello, Word Version: Word Office Standard 2010 I had to review this formula for it didn't work at first when trying to apply to the date, let alone for a merged field date from an excel file, due to several issues - mainly regional settings - european date format /...