I need help with a Function

[paggota78]

I need to be able to determine a future date from today's date by adding the # of days.

For example. I need to now what the date would be from today if I add 120 days.

Thank you for your help. I need this to track the freshness of beer in my warehouse.


This is the closet function I have been able to find


Calculate Number of Days Since Beginning of Current Year





Days since 1/1/2012 215






Calculate Number of Days Left in the Current Year





Days until 12/31/2012 151






A2 ="Days since 1/1/"&YEAR(NOW())
C2 =INT(((NOW()/365.255)-(YEAR(NOW())-1900))*365.255)



Please help.