and if??

[David]

I'm trying to check if two conditions are met, to use the
value in a non related cell.

For example, if a date is greater than the start date and
less than the end date, enter a value from A1, else enter
0.

Any thoughts?

Thanks, David.

 

[Chip Pearson]

David,

Try something like
=IF(AND(dateval>=startdate,dateval<=enddate),A1,0)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[Peo Sjoblom]

In the non related cell enter

=IF(AND(date_cell>start_date_cell,date_cell<end_date_cell),A1,0)

an example could look like

=IF(AND(D1>B1,D1<C1),A1,0)