Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Formula , Adding Days to a Date
A B
1 06/06/10 I want to make a formula that calculate as following; in Cell (B1) if the date in future the result will be [Enrolled], if not it will be Cell (A1) + 730 Days |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Formula , Adding Days to a Date
On Sat, 27 Mar 2010 02:14:01 -0700, Khalid A. Al-Otaibi
wrote: A B 1 06/06/10 I want to make a formula that calculate as following; in Cell (B1) if the date in future the result will be [Enrolled], if not it will be Cell (A1) + 730 Days Try this formula in cell B1: =IF(A1TODAY(), "[Enrolled]", A1+730) Format as date. Hope this helps / Lars-Åke |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for adding days to a date excluding weekends and holidays? | Excel Discussion (Misc queries) | |||
formula returns #VALUE! when adding days to a date | Excel Discussion (Misc queries) | |||
Adding days to a date cell to get a new date | Excel Worksheet Functions | |||
Adding 28 days to a date | Excel Discussion (Misc queries) | |||
Adding # of days to a date | Excel Worksheet Functions |