bill gras

Posts: n/a

datedif problem

Hi All
I need a date difference with a certain condition :
If AG44 is greater than 1 give me the date difference between T44 and TODAY(),
if AG44 is blank (has a formula that returns a blank cell) than give me the
date
difference between T44 and T45 and that needs to be coppied down to 3000 rows

can some one please help
regards bill
--
bill gras

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
Urgent Help Required on Excel Macro Problem	Sachin Shah	Excel Discussion (Misc queries)	1	August 17th 05 06:26 AM
Excel Display Problem	Bill Martin -- (Remove NOSPAM from address)	Excel Discussion (Misc queries)	0	April 19th 05 05:25 PM
Problem with Array Formulas and ISNUMBER	Henrik	Excel Worksheet Functions	1	February 10th 05 12:31 AM
Freeze Pane problem in shared workbooks	JM	Excel Discussion (Misc queries)	1	February 1st 05 12:04 AM
Row Autofit problem Excel 2003	Matthias Klaey	Excel Discussion (Misc queries)	0	January 19th 05 05:33 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us