hi Team,
i have 3 coloumns in which the coloumn A will have different status like Open,Closed, Availaible etc. Coloumn C have dates. i am trying to put a formula in coloumn B.
This is what i am looking for:
If the cell in coloumn A is "Open" or "Availaible", Date in Coloumn C - today's date - 35. For all other status in coloumn A, coloumn B should be blank.
Attached is the sheet.
Please help
Please Login or Register to view this content.
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
the formula is not working.
This is what i was looking for
If coloumn A = "Open" or "Availaible" then (Coloumn C)-(today())-35.
For all other status in coloumn A, coloumn B should be blank.
Try this...
=IF(OR(A2={"Open","Availaible"}),C2-TODAY()-35,"")
You've misspelled available. That 2nd i is the culprit!
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
You could have worked that out yourself.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks