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.
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.