#### rishijain11

##### Board Regular

- Joined
- Mar 29, 2006

- Messages
- 180

I'm trying to build out this excel file to keep track of my finances.

I could use some help with several formulas revolving around the pay schedule of a year. Any help would be appreciated and I can try toying around.

I have a hard-coded list of all the pay dates in a year, for a bi-weekly schedule in column A of my Sheet).

(side note - is there a way this can be formulated as well? if not, i suppose i would just need formulas that reference this list)

1. I'd like to create 2 formulas, that look at what today's date is, and then tells me how many business days until the next pay day (and also how many calendar days)

2. I'd like to create 2 formulas, that gives me a count of how many pay dates are left in the month. (also how many left in the year)

this would really help me start up from other formulas i'd like to create...i just had no idea how these would work...