calculate a date based on specified day of the month

T

tara

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top