ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Start/End Date Calcs (https://www.excelbanter.com/excel-worksheet-functions/112093-start-end-date-calcs.html)

LisaD

Start/End Date Calcs
 
I'm trying to fill-in cells with a value based on a start/end date. For
example:
State Date: 2-Oct
End Date: 23-Oct
Availability: .25

Would like the "Availability" value to drop in these cells:
2-Oct: .25
9-Oct: .25
16-Oct: .25
23-Oct: .25

Can I automate this without having to copy every time?
Thanks in advance!!
LisaD



All times are GMT +1. The time now is 08:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com