View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Date in cell + 77 days

Provided C5 contains a real date, then
In N7: =IF(C5="","",C5+77)
with N7 formatted as date to taste

If "dates" in C5, C6 etc are invalid/text (I suspect this is possibly an
issue), you could try converting that range of "dates" into real dates
recognized by Excel in one swoop using Data Text to Columns.

Select just the range of "dates", click Data Text to Columns. Click
NextNext. In
step 3 of the wiz, under Col data format, check "Date", then choose the
appropriate format from the droplist, eg: MDY. Click Finish. That should do
it, and it'll work fine.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"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