Posts: n/a

calculate day for day

I need a formula to calculate day for day for a 365 year. The only function
I can find in excel is days360.

For example: If I took a vacation from 1 mar 04 thru 10 mar 04 that would
be 10 days. Which I can do with SUM +1 but if the cells are blank I need the
amount of days to be zero (or blank) not 1.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculate time	Rao Ratan Singh	Excel Discussion (Misc queries)	2	March 17th 05 02:28 PM
How can I calculate Vacation Time earned based on length of emplo.	Kim	Excel Discussion (Misc queries)	2	March 15th 05 08:04 PM
formula to calculate # of days between dates, excluding holidays	abs2299	Excel Discussion (Misc queries)	8	March 3rd 05 02:21 AM
Not able to calculate.	mark_kramarczyk	Excel Worksheet Functions	1	December 29th 04 08:55 PM
How do you calculate the nth root of a number in Excel 2003?	William	Excel Worksheet Functions	2	November 17th 04 04:19 PM

All times are GMT +1. The time now is 11:20 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us