| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date formula
Hi there,
I want to set up a formula so that when I enter a date in one cell the cell with the formula gives me a date 4 days in advance. Any ideas? Many thanks, Will |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date formula
Just add 4 to it
=A1+4 if you mean business days =WORKDAY(A1,4,Holidays) where Holidays can be a range with public holidays -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "Will Emms" wrote in message ... Hi there, I want to set up a formula so that when I enter a date in one cell the cell with the formula gives me a date 4 days in advance. Any ideas? Many thanks, Will |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date formula
=c1 +4
will work after you format the cell "Will Emms" wrote: Hi there, I want to set up a formula so that when I enter a date in one cell the cell with the formula gives me a date 4 days in advance. Any ideas? Many thanks, Will |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date formula
Hi there,
That's great. Now do you have any idea how I can hide the values the formula is generating when the original date cell is blank or zero? Cheers, Will "Will Emms" wrote: Hi there, I want to set up a formula so that when I enter a date in one cell the cell with the formula gives me a date 4 days in advance. Any ideas? Many thanks, Will |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date formula
"Will Emms" wrote in message
... Hi there, That's great. Now do you have any idea how I can hide the values the formula is generating when the original date cell is blank or zero? Cheers, Will "Will Emms" wrote: Hi there, I want to set up a formula so that when I enter a date in one cell the cell with the formula gives me a date 4 days in advance. Any ideas? Many thanks, Will =IF(C4="","",C4+1) Regards. Bill Ridgeway Computer Solutions |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date formula
=IF(A1,A1+4,"")
Will Emms wrote: Hi there, That's great. Now do you have any idea how I can hide the values the formula is generating when the original date cell is blank or zero? Cheers, Will "Will Emms" wrote: Hi there, I want to set up a formula so that when I enter a date in one cell the cell with the formula gives me a date 4 days in advance. Any ideas? Many thanks, Will |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
| Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
| Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
| Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
| Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
![Will Emms[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
