ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Date in cell + 77 days (https://www.excelbanter.com/excel-worksheet-functions/219207-date-cell-77-days.html)

Mark

Date in cell + 77 days
 
Could someone help with a cell date + 77 days formula.

I'd like to enter that date to be

C5 (date is there) + 77 answer in N7
as a date 77 days from C7

Thank you in advance.

John[_22_]

Date in cell + 77 days
 
HI Mark
Just type in N5 =C5+77
Make sure your dates are real dates.
HTH
John
"Mark" wrote in message
...
Could someone help with a cell date + 77 days formula.

I'd like to enter that date to be

C5 (date is there) + 77 answer in N7
as a date 77 days from C7

Thank you in advance.



Mark

Date in cell + 77 days
 
easy and perfect, thank you both.. I have another, but it is more
complicated... coming up.
You guys are fantastic.
Mark

"Mark" wrote:

Could someone help with a cell date + 77 days formula.

I'd like to enter that date to be

C5 (date is there) + 77 answer in N7
as a date 77 days from C7

Thank you in advance.



All times are GMT +1. The time now is 11:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com