If the dates are entered in the normal mm/dd/yy format you simply subtract
the cell with the latest date from the cell with the earlier date. i.e.
=C12-B12 if the dates are in cells B12 and C12. If you are entering the
formula in D12 you willneed to format from a date format to a number format.

"TQ" wrote:

Hi, anyone who know the solution below ?

Start Date End Date 01.01.10~31.12.10
01.01,11~31.12.11
1)01/10/09 31/01/10 days ?
days ?
2)01/03/10 31/04/10 days ?
days ?
3)01/12/10 31/01/11 days ?
days ?


Is anyone know how to get the days which fall between the stimulate period
follow the info given ?

Thanks