Dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I return a date, six months plus the first of the following month
from a specified date? In other words, both January 1, 2005 and January 31,
2005 would return August 1 2005.
 
Hi

With specified date in A1
=DATE(YEAR(A1),MONTH(A1)+7,1)


Arvi Laanemets
 
You must log in or register to reply here.

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

Using if statements with a date 6
Excel Vba to change displayed year automatically. 14
Update cell value based on name and specific date 1
Mapping strings to integers 5
Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous 12
Error calculating date 1
Conditional Formatting with Dates (Revised) 5
Fiscal Year Calculation 13

Back
Top