Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
NFL NFL is offline
external usenet poster
 
Posts: 31
Default Counting Payments (Not Years or Days)

This spreadsheet will only be used to count payments - not days or years.
For example, the difference between bi-weekly and bi-monthly is that there
could be 3 payments required on any given month whereas the bi-monthly will
only require 2 payments. The way its' designed is that the end user will
enter the dates in Col A and the number of weeks, months, etc.. will appear
on the other columns. Here's the layout .... Hope this makes and also what's
been used. The Monthy and Semi-Monthly doesn't always work right...

col B formula: =INT((A3-A2)/7+1)
col C formula: =INT((A3-A2)/14+1)
col D formula: =E1*2
col E Formula: =SUM(F2, 1)
Col F Formula: =DATEDIF(A2,TODAY(),"m")

Col A Col B Col C Col D Col E
Col F
Weekly Bi-Weekly Semi-Monthly Monthly
Start Date B2 ... etc..
End Date B3 ... etc

Thank you!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i convert a number of days to years, months & days? SafetyLen Excel Discussion (Misc queries) 1 August 23rd 07 01:34 AM
Add years NOT days Coza Excel Worksheet Functions 3 March 23rd 07 01:32 PM
Convert years to years and days Kimmie B Excel Discussion (Misc queries) 3 February 7th 06 08:06 PM
convert Days to Years, Months, Days Klaudebou Excel Discussion (Misc queries) 3 December 29th 05 10:33 PM
Convert # of days to years/days Marlene Mayer Excel Discussion (Misc queries) 3 April 27th 05 02:27 AM


All times are GMT +1. The time now is 01:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"