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
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

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.