| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date formula that will return proper pay day
I need to set up a schedule that would list bi-monthly paydays based on the
15th and last workday of the month. When a pay day falls on a weekend or holiday it must change to the last workday prior to the 15th or the last workday of the month. Is there a simple formula I can use to list what those paydays would be? My formula goes on and on and I know there must be an easier way. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to return tomorrow's date. | New Users to Excel | |||
| Is there a formula that will return only the month from a date? | Excel Discussion (Misc queries) | |||
| how do i return to normal text from =PROPER(cell) | Excel Discussion (Misc queries) | |||
| Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
| Date formula: return Quarter and Fiscal Year of a date | Excel Discussion (Misc queries) | |||
![JJ in LA[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
