Formula extract the dates

jevi

Active Member
Joined
Apr 13, 2010
Messages
254
Office Version
  1. 2016
Platform
  1. Windows
Hi All,

I have a start date 01/01/2020 and an end date 13/11/2020. I did this formula so it can give me all the dates in H6 but it stops till 11/11/2020 and not 13/11/2020. So I can't understand why. Maybe C2 goes in the empty rows?
C2 = START DATE
C3 = END DATE
H6 = THE ROW WHERE I WANT THE DATE TO BE FROM H6 AND ON.

=IF($C$2+ROW(C2)>=$C$3;"";H6+1)

THANK YOU,
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
47,474
Office Version
  1. 365
Platform
  1. Windows
Try this min H6, copied down
Excel Formula:
=IF(ROWS(H$6:H6)>C$3-C$2+1;"";C$2+ROWS(H$6:H6)-1)
 
Solution

jevi

Active Member
Joined
Apr 13, 2010
Messages
254
Office Version
  1. 2016
Platform
  1. Windows
It worked like a treat:). thank you
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
47,474
Office Version
  1. 365
Platform
  1. Windows
You are welcome. Thanks for the follow-up. :)
 

Watch MrExcel Video

Forum statistics

Threads
1,118,134
Messages
5,570,361
Members
412,320
Latest member
sixnine0312
Top