Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Tom
 
Posts: n/a
Default How can I get excel to apply values in a cell before or after date

How can I get excel to apply values in a cell using an IF function before or
after dates displayed in another cell? It will allow me to use a
datevalue(...)= but not datevalue(...) or datevalue(...)<.
  #2   Report Post  
Biff
 
Posts: n/a
Default

Hi!

It's not very clear what you want. Be more specific. Post
examples of formulas you have tried.

Biff

-----Original Message-----
How can I get excel to apply values in a cell using an IF

function before or
after dates displayed in another cell? It will allow me

to use a
datevalue(...)= but not datevalue(...) or datevalue(...)

<.
.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Can an excel cell automatically change fill colors based on values John Clark Excel Discussion (Misc queries) 1 February 5th 05 05:21 PM
How Can I make a cell flash in Excel monir Excel Discussion (Misc queries) 0 February 4th 05 03:41 AM
excel locks up after selecting a cell sandenscot Excel Discussion (Misc queries) 7 January 28th 05 07:27 PM
Missing values in Excel Line Chart mw55309 Charts and Charting in Excel 1 January 19th 05 12:10 PM
display negative values as a blank cell in Excel Pheroze Bharucha Excel Discussion (Misc queries) 0 January 4th 05 10:51 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"