Formula:
=if(or(ao18="",au18=""),"xy",if(ao18<au18,"x","y"))
In the formula above, Y will display if submit date equals start date, as you haven't clarified what to do in those scenarios.
Formula:
=if(or(ao18="",au18=""),"xy",if(ao18<au18,"x","y"))
In the formula above, Y will display if submit date equals start date, as you haven't clarified what to do in those scenarios.
Please click the * icon below if I have helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks