Suzannah C. (job poster) hired Joe S. (Tasker) to help with this task. Got a similar task you need done?
Open
Assigned
Completed

Excel data validation formula

Posted by Suzannah C.

Location

Remote

Due date
Tuesday, 15th Aug 2017
Details
I am struggling to create a simple custom data validation formula!

Needed for 5 columns of a excel table.

Specifically - I need V7:V570 to allow either entry of a date (format dd/mm/yyyy) OR "Unknown" when typing into the cell.
Do not want a user to enter any other information apart from the above.

Thanks :)
Reviews
Suzannah C. left a review for Joe S.
“Did exactly what I needed and really fast!!! Thanks!”
Joe S. left a review for Suzannah C.
“It was pleasure helping Suz. Clear instructions and fast payment. Would love to help her again.”
Assignee
Joe S.
(309)
91%Completion rate

The percentage of accepted tasks this Tasker has completed.

Check my profile to see 5 star reviews and 100% completion rate in similar tasks.

Good luck

Joe
1 year ago
Task Activity
2 comments about this Task
Comments are now closed
you need to use and IF statement. Also need to set date format for cell
Happy to help now
Task Assigned
0 new tasks