
This Excel VBA tutorial explains how to convert date period to date row.
Excel VBA convert date period into date row
Different systems store date transactions differently. For example, if you apply for annual leave from Jan 1 to Jan 3, some system store the data in data base using date period
Begin Date
End Date
1/1/2018
1/3/2018
However some system store one date per row.
Begin Date
End Date
1/1/2018
1/1/2018
2/1/2018
2/1/2018
3/1/2018
1/3/2018
...
Read More