I am working on a spreadsheet for work to calculate the nearest years and months from today's date. I need this formula to round up to the nearest year. I have the formula worked out to calculate the nearest year, but how do I add the roundup function to the formula? Here is my info:
=DATEDIF(D3,NOW(),"y") & "." & DATEDIF(D3,NOW(),"ym")[/CODE]
for instance, one calculation comes up with 33.11. I need it to round up to 34. Using this spreadsheet for a mail merge.