Hi Ali, Its me Again :-D
There is only 1 mistake in your new formulas
For Example (See the cell i've Bold)
=IF($B2>$I2,"Error
Input",IF(TEXT(U$1,"ymm")=TEXT($B2,"ymm"),IF(TEXT(U$1,"ymm")=TEXT($I2,"ymm"),$I2-1,U$1)-$B2+1,IF(TEXT(U$1,"ymm")=TEXT($I2,"ymm"),DAY($I2)-1,IF(AND(TEXT(U$1,"ymm")>TEXT(*
Hi all,
I recently posted a topic to solve an issue regarding the span of total
number of nights spent in specific columns. The forum members were really
helpful, particularly De Premor!
Link is here:
https://groups.google.com/forum/#!searchin/excel-macros/Formula$20to$20span$20number$20of$2