Previous Topic Next Topic

HOW TO RETURN DATE IN EXCEL

Closed
Muhinuddeen Posts 1 Registration date Wednesday May 7, 2014 Status Member Last seen May 7, 2014 - May 7, 2014 at 07:37 AM
 Blocked Profile - May 7, 2014 at 02:23 PM
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 response

Answer 1 / 1
Blocked Profile
May 7, 2014 at 02:23 PM
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.


0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
If cell = date return yes or no.
JD -
ndwebb -

5 responses
WOW equipment return
aakash12345_0667 -
HelpiOS -

1 response