I have not included every fix, just those that are fairly major and not several days old. All new fixes will be posted here as well as at JPs
Days Remaining Bug
PROBLEM: Days remaining are not calculating correctly
REASON: the function =now() returns a time with the date. Once we are past noon, the difference between the start date and the current date is rounded up, causing the days remaining to be off. ie our start date is June 1st. Currently it is June 2nd. June 2nd minus June 1st = 1. With the time involved once we are past noon June 2nd minus June 1st will = 1.5..... This will then be rounded to 2, and even though there is still 60 days remaining it will show 59.
FIX: Open Sheet for editing, click on cell B5 and type =today() and hit enter. This function just returns the date and should correct this minor issue. As always the master sheet has been updated as well as any sheets I have access to.
PROBLEM: Days remaining are not calculating correctly
REASON: the function =now() returns a time with the date. Once we are past noon, the difference between the start date and the current date is rounded up, causing the days remaining to be off. ie our start date is June 1st. Currently it is June 2nd. June 2nd minus June 1st = 1. With the time involved once we are past noon June 2nd minus June 1st will = 1.5..... This will then be rounded to 2, and even though there is still 60 days remaining it will show 59.
FIX: Open Sheet for editing, click on cell B5 and type =today() and hit enter. This function just returns the date and should correct this minor issue. As always the master sheet has been updated as well as any sheets I have access to.