i want to add a number to a date and get the date as an answer eg...33 days added to 01.01.05
T traineeross Mar 9, 2005 #1 i want to add a number to a date and get the date as an answer eg...33 days added to 01.01.05
K Ket Mar 9, 2005 #2 You should be able to add the number to the date to obtain a result. eg A1 = 01/01/05, B1= 33 In C1 Type A1+B1. You may need to format the cell to show as a date.
You should be able to add the number to the date to obtain a result. eg A1 = 01/01/05, B1= 33 In C1 Type A1+B1. You may need to format the cell to show as a date.
B Bob Phillips Mar 9, 2005 #3 =A1+33 If you want to ignore weekends, then use WORKDAY(part of the Analysis Toolpak) =WORKDAY(A1,33) -- HTH RP (remove nothere from the email address if mailing direct)
=A1+33 If you want to ignore weekends, then use WORKDAY(part of the Analysis Toolpak) =WORKDAY(A1,33) -- HTH RP (remove nothere from the email address if mailing direct)
