| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If sate ment using edate
to keep my cell clear until someone enters data in another cell
I would like to do the following formula =IF($G15="", "",edate($G15.1)) This is not working G15 is a date I want to say if g15 has a blank field ,leave empty, if it is not empty take the date and add a month It is probably simple, please help |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If sate ment using edate
On Thu, 8 Mar 2007 03:14:33 -0800, Merge
wrote: to keep my cell clear until someone enters data in another cell I would like to do the following formula =IF($G15="", "",edate($G15.1)) This is not working G15 is a date I want to say if g15 has a blank field ,leave empty, if it is not empty take the date and add a month It is probably simple, please help =IF($G15="", "",edate($G15,1)) ^ You need a comma, not a dot. --ron |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If sate ment using edate
gee I feel stupid now
I fixed the period to a comma, but I tried it and getting the #name? error "Merge" wrote: to keep my cell clear until someone enters data in another cell I would like to do the following formula =IF($G15="", "",edate($G15.1)) This is not working G15 is a date I want to say if g15 has a blank field ,leave empty, if it is not empty take the date and add a month It is probably simple, please help |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If sate ment using edate
Just in case: go to TOOLS ADD-INS and make sure "Analysis ToolPak" is
checked. "Merge" wrote: gee I feel stupid now I fixed the period to a comma, but I tried it and getting the #name? error "Merge" wrote: to keep my cell clear until someone enters data in another cell I would like to do the following formula =IF($G15="", "",edate($G15.1)) This is not working G15 is a date I want to say if g15 has a blank field ,leave empty, if it is not empty take the date and add a month It is probably simple, please help |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If sate ment using edate
Thank you to both
"LongTermNoob" wrote: Just in case: go to TOOLS ADD-INS and make sure "Analysis ToolPak" is checked. "Merge" wrote: gee I feel stupid now I fixed the period to a comma, but I tried it and getting the #name? error "Merge" wrote: to keep my cell clear until someone enters data in another cell I would like to do the following formula =IF($G15="", "",edate($G15.1)) This is not working G15 is a date I want to say if g15 has a blank field ,leave empty, if it is not empty take the date and add a month It is probably simple, please help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| edate function | Excel Worksheet Functions | |||
| EDATE Problem | Excel Discussion (Misc queries) | |||
| edate function | Excel Worksheet Functions | |||
| EDATE | Excel Worksheet Functions | |||
| #NAME? error using EDATE | Excel Discussion (Misc queries) | |||
Linear Mode
