Start/End Date Calcs

L

LisaD

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count Dates in a range based on Column Header Id without using sum-product 1
Calculations using a start and end date: 0
Changing values in cell based on system date 2
Formula convert date to month format 7
End Date/Time adding business hours 1
Calculations using dates -- HELP! 0
Allocate Value Across Monthly Periods 1
LookUp (Date) Value from Forecast Data 8

Top