Page 1 of 1
Date problem
Posted: Wed Oct 13, 2021 9:27 pm
by sna
Hi dear,
I need your help to get date range in color cells base on start and finish date.
I attached a template
Thanks
Re: Date problem
Posted: Wed Oct 13, 2021 10:07 pm
by norkaz
...
C2:C10
=IF(ROWS($C$2:C2)=1,$B$2,IF(MONTH(EOMONTH(C1,0)+1)=MONTH($B$3),$B$3,EOMONTH(C1,0)+1))
Norkaz
Re: Date problem
Posted: Thu Oct 14, 2021 7:30 am
by sna
thanks it works but if I drag down it popped up more dates I don't need that
Re: Date problem
Posted: Thu Oct 14, 2021 9:54 am
by norkaz
...
C2
=IF(ROWS(C$1:C1)=1,$B$2,IF(ROWS($C1:C$2)>DATEDIF(EOMONTH($B$2,-1)+1,EOMONTH($B$3,-1)+1,"M"),"",IF(EOMONTH(EOMONTH(C1,0+1),0)=EOMONTH($B$3,0),$B$3,EOMONTH(C1,0)+1)))
Norkaz
Re: Date problem
Posted: Thu Oct 14, 2021 10:30 am
by sna
Thanks
Re: Date problem
Posted: Fri Jan 14, 2022 7:33 am
by sna
one more is there any formula to get dates like that but exclude public holidays?
TY
Re: Date problem
Posted: Fri Jan 14, 2022 10:15 am
by norkaz
..
Could you please provide the sample results?
Norkaz