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.
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.
=now()
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.
If you don't want to use IF else statement you can get the same result by using a logical test:
Code:=AND(A2>=D1,A2<=E1)
Bookmarks