date calculations

I wasn't sure how to search this - I've done searches, but none really address what I'm trying to accomplish -- but if you have another thread to refer me to, I'll go there! Otherwise, Ideas, please! I am moving my "to do" list from an online service that's raising its fees to an Excel...

Hello, I send order confirmations via Excel and With Outmail. Currently I use this formula in cell B1 to delay the delivery until 9AM. It works fine if I am entering orders before 9AM. =IF(NOW()>9/24,TODAY(),TODAY()+1). Problem is, sometimes I am entering customer orders at night, and I...

I'm trying to calculate how many bi-weekly checks total in a given month, how many have past month and how many are remaining. For example I used the formula "=3-(A3-MOD(A3-P$3-1,14)+41 >EOMONTH(A3,0))" to calculate total # of bi-weekly checks in any given month, A3 being the date of month in...

Hi, I have a list of start dates for employees (Month/Day/Year). I would like to calculate the difference in months between the month/day in which they were hired and July 1st. For instance, for someone hired August 15, 2010 the difference between July 1 and August 15 would be about 1.5...

Per example below, this is really racking my brain! How could I make the "Due Date" if it's not in between the pay period, for example, since today is Jan 24th, the 1st 4 bills should read "Day"FEB"16" and the last 2 should still read Jan as they are withing the pay period...

Hello, I have a spreadsheet that keeps stats for case workers caseload and I am running into issues counting cases that were opened prior to 2015 and were still open as of 1/1/15. I have names ranges for all my cell references, which I have many of. I have ranges for region, agency, assigned...

Greetings, Let's say I'm tracking my workouts at work. Suppose I had a chunk of text in a cell that looked like this: 8/30. Ran a mile around the building. 9/2. Treadmill. 9/19: Walked around the track. 9/20: Skipped jump rope in a fitness class. The number of dates can vary within cells. I...

I'm tracking some bank CDs that mature in several years. They pay interest on a semi-annual basis, every six months from the purchase date. I need a formula that will tell me the last time interest was paid, based on today's date. For example: Purchase Date: 10/26/10 Today's Date: 3/31/12 In...