MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Microsoft Excel dates


Posted by Emma Shaw on July 26, 2001 7:19 AM

I am trying to do a formula to pick up a cell only if it is between two specified dates?


Posted by Aladin Akyurek on July 26, 2001 7:21 AM

Care to elaborate?

Aladin

Posted by Emma Shaw on July 26, 2001 7:30 AM

I have a list of dates in column b, And if they are between 01.12.00 and 28.02.01 I need to return the value in column A

Posted by Ian on July 26, 2001 2:10 PM

Pardon???

"I have a list of dates in column b, And if they are between 01.12.00 and 28.02.01 I need to return the value in column A"

what is the value you need? (The date?)

Posted by Emma shaw on July 27, 2001 1:14 AM

Re: Pardon???