Posted to microsoft.public.excel.worksheet.functions

Dave H[_2_] Dave H[_2_] is offline

external usenet poster

Posts: 4

Today() and IF Function

Hello,
I'm trying to set up a formula to return cell C2 if A2 is x and B2 is within
180 days of todays date. Ex:
A B C
1 9/1/08 45784

This is what I've tried:

=IF(A2=x & IF(B2-Today()<=180),C2,"")

Any hints would be appreciated.

Dave

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
Do I use the TODAY() FUNCTION	Shweta Naik	New Users to Excel	2	May 8th 08 10:18 AM
I'm using the =today() function but I'm getting #####	Diefer87	Excel Worksheet Functions	3	March 18th 08 07:49 PM
Today() & Now() function	Luke	Excel Worksheet Functions	2	August 2nd 06 06:59 PM
Can you do a function like =TODAY() PLUS 1?	Donnie	Excel Worksheet Functions	6	August 9th 05 12:07 PM
Could anyone help me with (Today function), please?	azik	New Users to Excel	5	December 30th 04 02:09 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us