| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to return 1st of the month following 60 days
Hello -
I need, please, a formula to return the following. So, if someone started working with us on 10/15/09, the 1st of the month following 60 days of employment would be 1/1/10. That's what I need. THANK YOU! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula to return 1st of the month following 60 days
What about 1st of a month say 10/1/2009
'If you expect 1/1/10 then use =DATE(YEAR(A1),MONTH(A1)+3,0)+1 'if you expect 12/1/09 then use the below version =DATE(YEAR(A1-1),MONTH(A1-1)+3,0)+1 Regards Jacob "Jessica" wrote: Hello - I need, please, a formula to return the following. So, if someone started working with us on 10/15/09, the 1st of the month following 60 days of employment would be 1/1/10. That's what I need. THANK YOU! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula to return 1st of the month following 60 days
Try this...
A1 = some date =DATE(YEAR(A1+60),MONTH(A1+60)+1,1) -- Biff Microsoft Excel MVP "Jessica" wrote in message ... Hello - I need, please, a formula to return the following. So, if someone started working with us on 10/15/09, the 1st of the month following 60 days of employment would be 1/1/10. That's what I need. THANK YOU! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula to return 1st of the month following 60 days
=DATE(YEAR(A1+60),MONTH(A1+60)+1,1)
or (if you have Analysis ToolPak installed) =EOMONTH(A1+60,0)+1 -- David Biddulph "Jessica" wrote in message ... Hello - I need, please, a formula to return the following. So, if someone started working with us on 10/15/09, the 1st of the month following 60 days of employment would be 1/1/10. That's what I need. THANK YOU! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to Return the next 1st Tuesday of a Month | Excel Worksheet Functions | |||
| To detect month or days or year in if formula | Excel Discussion (Misc queries) | |||
| I'm looking for a formula to calc # of days left in a month | Excel Worksheet Functions | |||
| inputing different days in a month for a formula | Excel Discussion (Misc queries) | |||
| Formula for # of sales days in a month? | Excel Worksheet Functions | |||
Linear Mode
