Timeline for Excel conditional formatting date before weekend/holiday
Current License: CC BY-SA 3.0
8 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Feb 19, 2017 at 21:39 | history | edited | G-Man Says 'Reinstate Monica' | CC BY-SA 3.0 |
added 1 character in body
|
Feb 10, 2017 at 4:32 | history | edited | G-Man Says 'Reinstate Monica' | CC BY-SA 3.0 |
Added support for the Good Friday holiday.
|
Feb 10, 2017 at 4:26 | history | edited | G-Man Says 'Reinstate Monica' | CC BY-SA 3.0 |
Removed obsolete answer.
|
Dec 21, 2016 at 18:29 | comment | added | Michael Harris | I discovered a complication. We have Good Friday off which this year is April 14. Therefore, we will get paid on Thursday April 13. I suppose the same thing could happen at the end of the month as well since Good Friday (Easter) moves around. I have a formula that calculates the date for Good Friday. Is there a way to take that into account? | |
Dec 21, 2016 at 17:14 | vote | accept | Michael Harris | ||
Dec 21, 2016 at 17:13 | comment | added | Michael Harris | That worked. Thanks. It helped to format my numbers as date! | |
Dec 21, 2016 at 14:06 | comment | added | Michael Harris | I tried the formula but it did not work. I'm going to pick it apart and see if I can't figure out what is wrong. That will also help me understand it better. | |
Dec 21, 2016 at 7:28 | history | answered | G-Man Says 'Reinstate Monica' | CC BY-SA 3.0 |