HOW TO RETURN DATE IN EXCEL [Closed]

Report
Posts
1
Registration date
Wednesday May 7, 2014
Status
Member
Last seen
May 7, 2014
-
 Blocked Profile -
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??????????????

1 reply


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.


Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!