Add months and adding partial monhts
View Single Post
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.
On Wed, 27 Oct 2004 09:23:07 -0700, Adam C <Adam
When I need to add a month, to a date. I use -
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 -
My question is, how do I do this with one formula. It seems like a took the
long road to this solution.
Reply With Quote