| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need formula to calculate bi-monthly pay dates
I need to create a list or table that returns all pay dates for the 15th and
last day of the month for an entire year. The date must adjust forward when the normal pay date falls on a weekend or holiday, e.g. the 15th is Sunday so pay day is the 12th. My attempts have resulted in excessive formulas and no concrete answer. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to calculate elapsed dates. | Excel Discussion (Misc queries) | |||
| Formula to Calculate Dates | New Users to Excel | |||
| Help! ISO formula for inconsistent monthly dates | Excel Discussion (Misc queries) | |||
| Can someone help with a formula to calculate dates? | Excel Discussion (Misc queries) | |||
| How do I create a formula that will calculate monthly changes fro. | Excel Worksheet Functions | |||
![JJ in LA[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
