| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Date formula
Hopefully this is an easy one for all of your excel guru's. I have a cell called Date of Hire, I want the Date of Hire to populate another cell with the first of the month following the date of hire. How would I do that?
Thanks I really appreciate all the help this forum offers for people like me who are lost in excel. Thanks again! Renee |
|
#2
|
|||
|
|||
|
Nevermind - I figured it out! Thanks!
|
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date formula
Hi!
Try this: Assume A1 = date of hi =IF(A1="","",DATE(YEAR(A1),MONTH(A1)+1,1)) Biff "Seti" wrote in message ... Hopefully this is an easy one for all of your excel guru's. I have a cell called Date of Hire, I want the Date of Hire to populate another cell with the first of the month following the date of hire. How would I do that? Thanks I really appreciate all the help this forum offers for people like me who are lost in excel. Thanks again! Renee -- Seti |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Trending Formula Results by Date | Excel Worksheet Functions | |||
| Year-to-date year to date formula | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
Hybrid Mode
