Checking dates in Excel

[microam_i]

Hi,

I want to check whether a specific date falls within a time span or not in Excel.I have heard from my friends that it's possible but don't know whats the formula for it .Can anyone help me out.

[nitin_8]

=now()

[Darsheet]

Try to use the formula =IF(A2>D1,IF(A2<=E1,"True","False"),"False") where I've put the two dates into D and E on row 1.

[chroma]

If you don't want to use IF else statement you can get the same result by using a logical test:

=AND(A2>=D1,A2<=E1)