wcody
asked on
Column population based on date
i would like to have an X displayed in whatever column the expiration date listed in column B is versus todays date for each activity listed in column A.
The number in line 3 represent the days remaining before expiration of the license in the case of Auto registrations I filled in how I would like the sheet to work by plaing an X in the 365+ days reamining before license expiration.
If posible please give me a formula based solution and not a macro.
Thanks
Licensing.xlsx
The number in line 3 represent the days remaining before expiration of the license in the case of Auto registrations I filled in how I would like the sheet to work by plaing an X in the 365+ days reamining before license expiration.
If posible please give me a formula based solution and not a macro.
Thanks
Licensing.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sample formula for between 180 and 365
=IF(AND(B4-TODAY()<365,B4-
regards, barry
Licensing-barry.xlsx