View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tara Tara is offline
external usenet poster
 
Posts: 28
Default 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