Formula help

oakhayat

Hello everyone I hope you are doing great.

 

I need help with creating a formula for the following.

 

I have a drop-down list, with two items, Zakat and Tax.  I want to able to if I choose Zakat from the column A, column B prints today's date plus 90, and if I choose Tax it prints today's date plus 60

 

Thanks for your help   

Andrée Starå

Hi,

Try this.

=IF(ColA@row = "Zakat"; TODAY(90); IF(ColA@row = "Tax"; TODAY(60); ""))  

The same version but with the below changes for your and others convenience.  

=IF(ColA@row = "Zakat", TODAY(90), IF(ColA@row = "Tax", TODAY(60), ""))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting