HOW TO RETURN DATE IN EXCEL Closed

Question

Hi ,

pls give me answer for this question


	        A	              B             C            	D	             E                       F
1	GUEST NAME	HOTEL	CHECK IN	    CHECK OUT	   AMOUNT     DEADLINE
2	MR. RAMESH	ATLANTIS	14-May	   18-May	           1500	
3						
4						




How Can I return the date 3 days prior to Check in date in Cell F1 if the Hotel Name is Atlantis??????????????

ac3mark · Answer

Man this really sounds like a Home work question.

Ok, but to give you some direction, you must use the if(logic_test,true,false) structuring.

Have a go, and let us know where you are stuck.

HOW TO RETURN DATE IN EXCEL

1 response

Similar discussions

Subscribe To Our Newsletter!