Previous Topic Next Topic

Using if with a fixed date

Closed
BIBO - Apr 25, 2016 at 03:29 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Apr 25, 2016 at 09:15 AM
Hello,

im trying to use a if statement in excel with a fixed date =if(A2="Active",E2=Date(2016,03,31),"Closed") but it returns a 1900/01/00 date please help


1 response

Answer 1 / 1
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Apr 25, 2016 at 09:15 AM
BIBO, Good morning.

Try to do:

Cell E2 --> =IF(A2="Active",Date(2016,03,31),"Closed")

Format E2 as DATE

I hope it helps.