Gizmo's Freeware is Recruiting

Gizmos Needs YouWe are currently looking for people with skills and/or interest in the following areas:

- Rootkit Scanner and Remover
- Web Browser for Android

If this sounds like you then click here for more details

 

# of days

Updated 31. July 2008 - 2:46 by malagodi

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.

 

by Urbane.Tiger on 4. August 2008 - 22:50  (5555)

this may help http://www.acutesoftware.com.au/ - bottom of page,

by mikedutch (not verified) on 2. August 2008 - 23:28  (5372)

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
by kunkel321 on 7. August 2008 - 17:15  (5764)

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
by kunkel321 on 2. August 2008 - 16:25  (5359)

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
by cy (not verified) on 3. August 2008 - 1:52  (5381)

Thanks Steve :) this one makes me really curious. Didn't know it, silly me.

--
always look on the bright sight of life...
by tony on 1. August 2008 - 22:27  (5331)

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

by kunkel321 on 1. August 2008 - 15:27  (5313)

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
by cy (not verified) on 31. July 2008 - 22:00  (5276)

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