Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a worksheet with columns that represent the dates that I get paid. I
get paid on the 15th and 30th of each month, unless, it is Feb, then the last day of the month (28th or 29th). I want to be able to have the date calculated automatically. I can figure the calculation for the 30th (previous date + 15), but I don't know if there is an easy way to calculate the 15th since the number of days in a month vary. Any help greatly appreciated!! Les |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date Calculation | Excel Worksheet Functions | |||
Tricky Date calculation: How to calculate a future date | Excel Discussion (Misc queries) | |||
Date calculation | Excel Worksheet Functions | |||
Need help with a date calculation | Excel Discussion (Misc queries) | |||
Date Calculation | Excel Worksheet Functions |