Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Turns Green 90-Days before the date shown in cell | Excel Worksheet Functions | |||
Adding days to a date cell to get a new date | Excel Worksheet Functions | |||
is it possible for a cell to change a date every 7 days ?? | Excel Worksheet Functions | |||
How to put todays date in one cell then the next cell adds x days | Excel Discussion (Misc queries) | |||
formula to calculate future date from date in cell plus days | Excel Worksheet Functions |