tricky if formula

Hi Expert's excel 2007

I need to amend current formula to add the following condition...additional criteria


If g2 and h2 both have no dates then c2..
Who is Participating?
Naresh PatelConnect With a Mentor TraderCommented:

Sorry Spelling is wrong in formula this is revised one.
Naresh PatelTraderCommented:
route217Author Commented:
You superstar. ..itjockey. ..


Just double checking
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

route217Author Commented:
Ok...slightly problem...when g2 has a date and h2 us blank in addition to the above then return complete. ..if g2 is blank and h2 gas date then in progress
Naresh PatelTraderCommented:
Just to inform you that =CELL("Format",G2) return to "D1" if G2 date format is "d-mmm-yy or dd-mmm-yy". if there is some different format then modify formula as per format. below is list of Returning value & its format.

"D4"         - m/d/yy or m/d/yy h:mm or mm/dd/yy
"D1"         - d-mmm-yy or dd-mmm-yy
"D2"         - d-mmm or dd-mmm
"D3"         - mmm-yy
"D5"         - mm/dd
"D6"         - h:mm:ss AM/PM
"D7"         - h:mm AM/PM
"D8"         - h:mm:ss
"D9"         - h:mm

Naresh PatelTraderCommented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.