ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

 Adam C October 27th 04 05:23 PM

Hi -

When I need to add a month, to a date. I use -

=DATE(YEAR(B27),MONTH(B27)+S21,MIN(DAY(B27),DAY(DA TE(YEAR(B27),MONTH(B27)+S22,0))))

However, I sometimes need to enter 1.5 months or 2.5. I figured out a way
to do this by looking at the number and figuring out if it is a decimal then
adding the decimal to the days -

=DATE(YEAR(N26),MONTH(N26),DAY(N26)+(DAY(P26)*L26) )

My question is, how do I do this with one formula. It seems like a took the

Any suggestions?

 Myrna Larson October 27th 04 06:47 PM

If you can resolve what you mean by half a month, then just add that number of
days. Month length is between 28 and 31. If you decide half a month is 15
days, you should be able to include that in the DAY part of your formula.

wrote:

Hi -

When I need to add a month, to a date. I use -

=DATE(YEAR(B27),MONTH(B27)+S21,MIN(DAY(B27),DAY(D ATE(YEAR(B27),MONTH(B27)+S22,0))))

However, I sometimes need to enter 1.5 months or 2.5. I figured out a way
to do this by looking at the number and figuring out if it is a decimal then
adding the decimal to the days -

=DATE(YEAR(N26),MONTH(N26),DAY(N26)+(DAY(P26)*L26 ))

My question is, how do I do this with one formula. It seems like a took the