Posted to microsoft.public.excel.worksheet.functions

martyn

external usenet poster

Posts: 12

Date formual issue

Hi everyone

I have two colums with dates in and I want to subtract one from the other so
so I can get hte dumber of days between the two, this is the east part. The
problem I have is when one of the colums is blank I want to use todays date
so I can avoid #VALUE! being returned, I been reading a looking up posts here
for the best part of two hours and can not find the answer, can anyone help
me please?

Many thanks
Martyn

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
8000 formual issue	Chris	Excel Discussion (Misc queries)	1	September 5th 07 08:21 PM
Date issue	Jim Savage	Excel Discussion (Misc queries)	7	February 9th 07 03:48 PM
DATE ISSUE!	Joan	Excel Worksheet Functions	2	June 15th 06 03:39 PM
Date issue	polk383	Excel Worksheet Functions	3	June 10th 06 06:21 PM
equal sign in front of date in formual bar	Ron 130	Excel Worksheet Functions	1	April 5th 06 10:23 PM

All times are GMT +1. The time now is 11:59 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us