I need a program that counts down the # of days remaining until a certain date.
A feature that would count the # of working days, with holidays / vacation days calculated out would also be nice.
| Attention: Webmasters and SEO specialists - This community site needs YOU
We are currently seeking folks with specialist website promotional skills to join our Promotion Management and Planning group to help with the task of improving our site's global visibility. If you have a strong background in SEO, some spare time to help out, and would like to contribute to our community effort to make this the web's largest and most useful freeware site, then please contact Chris, the group coordinator, using our site contact form. |
Don't miss out on our latest freeware finds. Get the latest via our site RSS feed 
this may help http://www.acutesoftware.com.au/ - bottom of page,
This PolarSoft Date Calculator looks like it does exactly what you want but I haven't gotten it to run on my system:
http://www.polarsoft.de/html/polarsoft_-___ps_date_calculat.html
If you don't mind spending a bit of money these look like they do what you want too:
http://www.datecalculator.com/index.cfm?id=7
http://computersolutioncentral.com/date_calculator.html
Mike Douwe posted this spreadsheet formula on another site:
=((A2-A1)*24)-((COUNTIF(C1:C8,"<"&A2)*24)-(COUNTIF(C1:C8,"<"&A1)*24))
Start date and time in A1
End date and time in A2
Holiday list in C1 to C8 (allows 24 hrs for each holiday)
Format formula as general
Here's another site that talks about using NetworkDays:
http://sysdev.uncc.edu//HowTos/Excel/networkdays.htm
If you use Crystal Reports see here:
http://www.kenhamady.com/form01.shtml
Apple support has another formula:
http://docs.info.apple.com/article.html?artnum=55804&coll=ap
RE spreadsheet formulas ...
in A1 put =TODAY().
in A2 put a future date.
Somewhere else put =A1-A2 and hit Enter. Be sure to format as "Number." This gives the number of days into the future the other date is.
Using the today() function is advantageous because if you open your spreadsheet in the future it will reassess "today" and adjust it's output accordingly.
Now in column B make a list of holidays (for example in B1:B20).
Somewhere else put =NETWORKDAYS(A1,A2,B1:B20) and hit Enter. This does the same, except it excludes weekends and whatever dates are in the holiday list.
-steve
========
steve
Hi again, I was just tinkering with WiseCalc http://www.wisecalc.com/.
I'm not sure where I learned about it (here?) It's super-powerful but has a STEEP learning curve.
Anyway... I just noticed that you can calculate time differences (I don't think you can exclude holidays though).
========
steve
Thanks Steve :) this one makes me really curious. Didn't know it, silly me.
--
always look on the bright sight of life...
Have you tried Rainlendar or some other from this editotial http://www.techsupportalert.com/best-free-pim.htm. I use Rainlendar it it seems to do what you suggest
Tony
As CY says, use a spreadsheet. I know that with Excel you can use a functioned called =NETWORKDAYS(). Look it up in the help files or Google it to see how to use it. I'm sure the Google Apps Spreadsheet works the same.
========
steve
Try a spreadsheet, works fine :)
Look for Gnumeric here...
http://www.techsupportalert.com/node/168
--
always look on the bright sight of life...
Post new comment