[Solved] Using EDATE in a formula

[cephas]

Recently I had a few problems with sorting incremented dates, see Sorting incremental dates . That's now solved. A new problem came up. The resolve worked perfectly where the entry used a number of days. There were some entries that have a recurring payment monthly. How does one use EDATE ?

The solution was provided by Mr. Programmer , see the supplied file at download/file.php?id=49450

[cephas]

The new modifications to the formula works perfectly, for number of days and where the entry is monthly. However, some entries are every 2,3 4 or 6 months, for example

Code: Select all

=EDATE(D123,6)

not sure how to cater for that. I guess, for a 6 monthly frequency, I can specify "182" in the "Repeat" column though.

[cephas]

It's fine how it is actually, I can use days or "Monthly". At the most it will only be 1 day out. Thanks for your help.