@kisho_Hto clarify, all dates become thursday, but friday and saturday will not convert to the next weeks thursday instead they will go back a day or two to the previous thursday instead going to next weeks thursday, is there any way to fix this in the function =IF(L4="","",L4+4-MOD(L4-1,7))

I put this into google sheets and to make the dates become next thursday but I have not been able to get it to work especially for the dates right after thursdays. =IF(L2="","",L2+4-MOD(L2-1,4)) is the function i used to make it thursday but not all dates were thursday.

So informative things are provided here, I really happy to read this post, I was just imagine about it and you provided me the correct information. I really need this for my site.

What Andy says is true. Changing commas and points through the OPTIONS ADVANCED, fully messes up the system

@crystalThis works but is not persisted. I can successfully remove future occurrences of a meeting, until it re-syncs with Exchange which then puts the meetings back.

This is brilliant! Thanks, Chris H

@WinnieI need the same thing! I need two or three sets of values that are then inserted info a formula. One set of values is e.g. Green =1, blue = 2, red = 3 etc. And the other set of values is let's say square = 4, triangle = 3, circle = 0, etc. This code helped making one such dropdown, but I can't figure out how to make one more on the same sheet.

For Windows 10: Settings>System>Sound>Sound Control Panel

I have the same/similar question. I am trying to sum all of the columns to the right of the reference cell but it only sums the one. How do I get it to sum all those to the right individually?

Please kindly explain : (Renaming doc) You could do this using the REN function if you open the CMD in the folder with the documents saved - and also 2 pages docs into one pdf