Hello everybody.
I need a help related to formulas with dates.
I have a start date (10/02/2014) and an end date (30/10/2014) when compared with the date "eg: Jan / 14 must show" 0 "on the worksheet, where to Feb/14 should show "1" until Oct/2014.
Ex:
Start date End date jan/14 fev/14 mar/14 abr/14 mai/14 jun/14 jul/14 ago/14 set/14 out/14 nov/14 dez/14 jan/15 fev/15 mar/15
10/02/2014 30/10/2014 0 1 1 1 1 1 1 1 1 1 0 0 0 0 0
06/12/2013 30/05/2014 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0
02/10/2013 30/03/2014 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0
Thanks.
Bookmarks