Dates

  • Thread starter Thread starter DaveKid
  • Start date Start date
D

DaveKid

Hi, I would like to be able to produce a date which is automatically 3 months
ahead of a date in another cell. How do I do this?
 
=DATE(YEAR(A1),MONTH(A1)+3,DAY(A1))
You will, of course, need to ask yourself the usual questions, such as what
date do you regard as being 3 months after November 30th.
 

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

Similar Threads

Date with CF 4
Excel Vba to change displayed year automatically. 14
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
help with date formula 1
footer date plus 3 months 4
If statement with dates 0
Excel High lightng dates in future, today and past 1
Group Dates 3

Back
Top