Timeline for The Work Day Countdown

Current License: CC BY-SA 4.0

9 events

when toggle format	what	by	license	comment
Jun 17, 2020 at 9:04	history	edited	Community Bot		Commonmark migration
Oct 3, 2018 at 16:28	comment	added	Luis Mendo		Glad that works. I removed the downvote
Oct 3, 2018 at 16:02	comment	added	Keeta - reinstate Monica		@luisMendo Yes, that works. I didn't see any clarification. If it had been to not count last day instead, I could have =NETWORKDAYS(NOW(),A1-1). I knew it would always be the same byte count no matter which clarification.
Oct 3, 2018 at 16:00	history	edited	Keeta - reinstate Monica	CC BY-SA 4.0	Updated to not include today, per OP clarification of whether to not count today or last day.
Oct 3, 2018 at 7:42	comment	added	Erik A		The format is not standard, it's locale-based. Excel reads the format from the `HKCU\Control Panel\International\sDecimal` registry string. On a default US Windows installation that's MM/dd/yyyy. In most EU countries this would be the default.
Oct 2, 2018 at 18:47	history	edited	Keeta - reinstate Monica	CC BY-SA 4.0	Added screenshot of date formatting.
Oct 2, 2018 at 18:40	comment	added	Taylor Raine		unfortunately, the community has decided that languages need to be run under their default settings to be valid (the one exception that I have seen to this is language - IE, if your language supports both English and Spanish, you may readily use either, but this must be noted.) Further, OP (@hille) has not stated that format is flexible, and has in fact stated quite the opposite (see second comment on this question)
Oct 1, 2018 at 19:57	comment	added	Taylor Raine		While this works with date values, it fails to take input as stated. That is (at least in the US version) `10.12.2018` is a string when held in a cell rather than a date. The obvious but long solution to correct this would be to change `A1` to `DATE(RIGHT(A1,4),MID(A1,4,2),LEFT(A1,2))` in your solution
Oct 1, 2018 at 18:51	history	answered	Keeta - reinstate Monica	CC BY-SA 4.0