Atomic and molecular gas in interstellar cirrus clouds