cell phone billing cycle minutes

[Chenboy2]

I'm trying to calculate the average number of cell phone minutes I can use every day during my billing cycle.

F3 is today's date, C3 is the end of the billing cycle.

My current formula is as follows:

IF(F3<C3,NETWORKDAYS(F3,EOMONTH(F3,0)+19),NETWORKDAYS(F3,EOMONTH(F3,-1)+19))

Right now I can't find a way to create an IF function where it would switch from EOMONTH(F3,0)+19 to EOMONTH(F3,-1)+19 as it goes to the new month.

Is there a way to do this?

 

[JokelesComedian]

Not sure what you are looking for but if you use the function

=DATEDIF(Later Date,today(),"d")

The later date is after today() and the "d" will count by days. If and count down to 0 and choose that way. But I need more info to understand exactly what you want.

 

[Chenboy2]

The formula is supposed to read,
=IF(F3<C3,NETWORKDAYS(F3,EOMONTH(F3,0)+19),NETWORKDAYS(F3,EOMONTH(F3,-1)+19))

I'm having difficulty making C3 become the calendar date of end of the month that it passes regardless of when it is during the cycle.

For example: the billing cycle always begins on the 20th and ends on the 19th of the next month. Because the cycle ends the next month, end of the month is volatile based on when the current date is. If today is March 22, then I want C3 to read March 31 and not April 30 since the billing cycle ends on April 20, which would be for the next billing cycle.

What can I replace C3 with to make it do this?

 

[Chenboy2]

For some reason the formula is not showing up. I've broken it up.

=IF(F3 < C3, NETWORKDAYS (F3,EOMONTH (F3,0)+19), NETWORKDAYS (F3, EOMONTH(F3,-1)+19))

If I haven't explained what I was trying to do with this formula, I want to be able to count the days remaining in my cell phone cycle, not including weekends.

 

[barry houdini]

If you subtract 19 from today's date that will give you a date in the last month if you are at or before 19th, or a date in this month if you are at the 20th or later.......so using that logic try this formula

=NETWORKDAYS(F3,EOMONTH(F3-19,0)+19)

....or if you still want to use C3 use just this part in C3 to get a dynamic formula for the next end date

=EOMONTH(F3-19,0)+19

then for days remaining you just need

=NETWORKDAYS(F3,C3)

 

[Chenboy2]

Hey, I think it works. Thanks!