hi guys,
I'm trying to create a formula that will give me a number based on the differences between dates. If the dates are the same (L2=B2) the cell should list -24 and if the dates are are different (04.02.2015, 05.02.2015) the cell should list 24. If the dates show 04.02.2015 to 06.02.2015 the cell should list 48 and so on.
so far I only have =IF(L2=B2,-24,IF(L2<B2,24,)), however this wont show 48, 72 etc.
screenshot time in motion.png
some members cannot open pictures (restrictions on their network policies) so it is better to post sample workbooks.
maybe something like this could help
=IF(L2-B2=0,-1,L2-B2)*24
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks