Home |
Search |
Today's Posts |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Previous Pay Dates
Here are slightly shorter versions of the previous formulas
=--(TEXT(MONTH(NOW()),"mmm")&IF(DAY(A1)<=15,1,15)) and =IF(DAY(A1)15,EOMONTH(NOW(),0),--(TEXT(MONTH(NOW()),"mmm")&15)) The EOMONTH is part of the ATP in Excel <=2003 so you may need to attach it- Tools, Add-ins, and check the Analysis ToolPak -- If this helps, please click the Yes button Cheers, Shane Devenshire "NFL" wrote: I have a cell reference that has a begining date (for example Apr 1, 1994) and payments should have been made on the 1st and 15 of the month every month up to the present. Is there a way a formula that can be written that way? I also need a similar formula, but the start date would be the 15th of the month. These payments will be made on the 15th and the end of the month. The end of the month could be 30, 31, 28, or 29 (depending on leap year). With this formula, we could gather totals on the other column to check to see when payments were made and keep a running total. Thank you for your help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating values where it depends on the value of a previous cel | Excel Discussion (Misc queries) | |||
Working with dates previous 1900 | Excel Discussion (Misc queries) | |||
Count dates for previous month | Excel Worksheet Functions | |||
Calculating monthly totals for current and previous year | New Users to Excel | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) |