EXCEL question.

[Deleted User]

I have an EXCEL spreadsheet, where I input my daily electricity usage. This works out the units used from the previous day, and it accurately predicts my monthly bill. One of the calculations involves finding the average by taking the amount of units used, and dividing by the number of days elapsed since the beginning of the billing cycle(cycle starts on 14th, so today the number of elapsed days is 27 and so on), then simply multiplying the average by the number of days in the month to get a monthly prediction. I know it's a trivial thing but is there a function in EXCEL that will increase the elapsed days automatically without me having to manually input ? Not important but I'm just curious. Was many years ago since I did any programming, so any help appreciated.

[Deleted User]

Think you have the wrong section of the forum. 

tacpot12

This should be asked in the Technical section, but pending it being moved, I think this formula will do what you want:
=INT(IF(DAY(NOW())<14,NOW()-DATE(YEAR(NOW()),MONTH(NOW())-1,14),NOW()-DATE(YEAR(NOW()),MONTH(NOW()),14)))

This will return a number between 0 and 30 depending on the number of days between todays date and either 14th of the current month (if today's date is 14th or greater), or the 14th of the previous month (if today's date is less than 14th of the month). 

MattMattMattUK

You could use COUNT to count the number of days with a value in to then divide the total by, or if you use the AVERAGE function but leave the future days blank it will calculate the average only of the days that have been entered.

[Deleted User]

Thanks everyone.