Hi,
I'm looking for some help. I'm fairly new to formulas in excel and I'm having trouble. What I needs is:
If cells (G4,G10:G16) have a date (of cert completion) entered. I need G17 to display "Yes".
Is there such a formula out there?
Thank you much
There is no function (maybe a user defined one) in excel to tell you if a cell contains a date or not.
This solution will take into account if the cells have any kind of value in them.
=IF(COUNTA(G4,G10:G16)=8,"Yes","")
If all 8 cells are populated then it returns "yes" otherwise it remains blank.
(what you can do is to use "cell validation" in those cells to allow only for date format)
Last edited by Portuga; 04-09-2008 at 05:26 PM.
If you found the solution to your question. Mark the thread as "Solved"
Thank everyone that helped you with a valid solution by clicking on their
There is no such thing as a problem, only a temporary lack of a solution
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks