Month Roll up

[Daren]

Hi

I have a question, i am trying to automatically roll up the month on a date.

Example;

DUE DATE TODAYS DATE
26/05/2002 TODAY()

What i need to say is, IF DUE DATE = TODAY() then change DUE DATE to the next month (26/06/2002).
The day will never change but the month always will. So when TODAY() = 26/06/2002 then change it to 26/07/2002, so on, so on. This will always be in the same cell.

Can this be done?
This is what i tried: IF(A1=B1,A1+31,A1) Result = 00/01/1900

Any help on this would be much appreciated.

Daren

[sann0638]

Daren,
use the EDATE function, where EDATE(Date,1) adds a month. You will need to install add-ins.

[pp2002]

Hi Daren,

I used IF(A1=B1,A1+31,A1) and got the correct date? I already use this.

I had to format the cell to the date type I required.

Paul

[Ian Mac]

On 2002-05-21 08:15, pp2002 wrote:
Hi Daren,

I used IF(A1=B1,A1+31,A1) and got the correct date? I already use this.

I had to format the cell to the date type I required.

Paul

there are not always 31 days in a month EDATE() is a much better way of doing if.

[pp2002]

Ian

Good point! I will try this.

Thanks

Paul

[Daren]

Hi thanks for the responses.

I re-tried the formula but still the same answer? 00/01/1900 I tried changing the format but no joy?
Curious about the EDATE function, as I haven’t used this before, could someone send me an example of what I’m trying to do?

Is it possible place the start date in cell A1: then say if the value in A2: is the same date, then forward A1: by one calendar month.

Thanks

Daren

[TroyBoy]

You might wish to due a search for the thread called Date Incrementing Woes started by me. Sounds like you wish to do just about the same thing I am.

Peace!

Troy