Posted to microsoft.public.excel.misc

Henk

external usenet poster

Posts: 80

Calculating with dates

Yes it worked

Thanks for your help

Henk

"Lisa" wrote:

try:
=a2-counta(b2:d2:)
so, days less the count of days taken (I'm assuming this is what you meant
to do?)

"Henk" wrote:

I have a question regarding days and substracting days as a date.

This is my excel sheet

personal Day Day Day Remaining
days Taken Taken Taken Days

3 05/07/07 06/05/07 1

Is there a way with a formula to calculate the remaining days without
entering another column with a number ?

I hope this is understandable.

Thanks

Henk

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Calculating dates	Toby0320	Excel Worksheet Functions	11	July 18th 06 04:52 PM
Calculating dates	alen_re	Excel Discussion (Misc queries)	2	January 25th 06 10:32 AM
Calculating number of days between two dates that fall between two other dates	[email protected]	Excel Discussion (Misc queries)	5	October 26th 05 06:18 PM
I need help calculating dates?	jeda67	Excel Worksheet Functions	4	August 30th 05 02:14 PM
calculating dates	Kira	Excel Worksheet Functions	1	August 3rd 05 08:37 PM

All times are GMT +1. The time now is 12:30 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us