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())
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment