| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dates
=IF(A1="","",... formula to suit ...)
-- David Biddulph "Jody" wrote in message ... that works perfect - I have one more question - If the date cell is blank - I want the cells that have formulas in them to also have blanks so then when you put the date in the original cell it all populates. I am so rusty on doing this - Thanks a million for your help... "David Biddulph" wrote: You might try =DATE(YEAR(A1+30),MONTH(A1+30)+1,1) =DATE(YEAR(A1)+1,CEILING(MONTH(A1),3)+1,0)+1 -- David Biddulph "Jody" wrote in message ... I need to calculate a date and need help... Enter a hire date in one cell and then I need to calculate 1st of the following month after 30 days? Enter a hire date in one cell and then I need to calculate 1st of the following quarter after 1 year? For some reason I am brain dead today - if anyone could help - it would be greatly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I sort a column of random dates into Consecutive dates | Excel Worksheet Functions | |||
| Identifying unique dates in a range of cells containing dates... | Excel Discussion (Misc queries) | |||
| Identifying unique dates within a range of cells containing dates | Excel Discussion (Misc queries) | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
![David Biddulph[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
