Posted to microsoft.public.excel.worksheet.functions

Amatuer

external usenet poster

Posts: 2

Need IF/THEN formula for date present

I'm sure this is basic for most of you but it is baffling me:

I need a formula to subtract date column 1 from date column 2 (that part I
have) AND IF there is NOT a date in date column 2, subtract date column 1
from TODAY's date. Thanks!

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
present value formula	SUMIF	Excel Worksheet Functions	2	September 26th 06 03:28 PM
how do I automatically jump to the present date in a roster?	awvanheerde	Excel Worksheet Functions	3	July 19th 06 03:53 PM
calculating month of present date	anu_manu	Excel Discussion (Misc queries)	5	February 24th 06 07:04 PM
How do I show dates older than present date?	Sissyfirst	Excel Worksheet Functions	1	July 12th 05 09:56 PM
Understanding net present value formula in Excel	kathy304	Excel Worksheet Functions	1	February 1st 05 07:15 PM

All times are GMT +1. The time now is 09:57 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us