Converting EXCEL to Fillable Form - Dates ranges

[Katie25540507w2c6]

I am converting an Excel document to a filllable PDF. The only issue is am running in to is with dates. In the Excel doc, you enter a date range(Pic1), and then using a couple simple formulas, a date range populates on a table in the excel document. 

Is there anyway to duplicate this without using Java?

  Pic 1

 Pic 2

Thanks!

[try67]

Sure. You would need to read the first field's value, convert it to a Date object and then use a loop to add to it one day at a time, writing out the new date to one of those fields, until you reach the final date.

However, unlike in Excel where you can have an unlimited (more or less) number of rows you can write this data to, in Acrobat the fields you're writing it to have to exist in advance, especially if you want the file to be usable in Reader.

[Katie25540507w2c6]

Any chance you could give me some screen shots to serve as examples of the actions you're outlining above?

Much appreciated.

[try67]

Screenshots will not help you here. You need to write the actual code to do it.