| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculate a date based on specified day of the month
I need to be able to enter a day of the month (1st, 5th, 10th, 15th, 20th,
25th) and get the next available date with that day in it. confusing.... ok if I put a 5 in a cell today , I need another cell to come up with 3/5/09 . If I put a 5 in a cell on 4/10/09, the other cell should come up with 5/5/09 and so on for each of the available payment dates. Did I give enough information? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to calculate a date: first day of the month after 60 days | Excel Discussion (Misc queries) | |||
| how to calculate a month without the full date? | New Users to Excel | |||
| Calculate 1st of month date from existing date. | Excel Discussion (Misc queries) | |||
| Calculate month-end date from date in adjacent cell? | Excel Worksheet Functions | |||
| Excel: Is there a way to calculate the date as week of month? | Excel Discussion (Misc queries) | |||
Threaded Mode
