Sunday, December 4, 2011

How do I create an If/then statement in excel to show a specific date based on a criteria?

For example. IF (Column (A) = "florida", then column (B) = Today() - 14, if Column a = "not florida", then column B = Today(). essentially i only want the column to calculate todays date - 14 days if column a says Florida, if not then I would like it to simply show todays date|||In B1:





=IF(A1="florida",Today() - 14,Today())

No comments:

Post a Comment