Formula to find Current/ future date based on specific date given

[Aswinraj]

Hello Friends,


I have column which contains only dates and blanks - based on Date Column it has to provide the information as Current or Future date.


Based on table below,


If Column A is Lesser than or Equal to 30th Sep 2018 then Column B should show as "Current"
If Column A is Greater than 30th Sep 2018 then Column B should show as "Future"
If Column A is Blank then Column B should show as "#N/A"


Column A Column B


30/09/2018 Current
21/08/2018 Current
01/10/2018 Future
#N/A
03/10/2018 Future




With Regards,
​​​​​​​Aswinraj A

 

[RasGhul]

Try

=IF(A1="","#NA",IF(A1<=DATE(2018,9,30),"Current","Future"))

 

[Aladin Akyurek]

Something like:

=IF(ISNUMBER(1/A2),IF(A2>DATE(2018,9,30),"Future","Current"),#N/A)