LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,593
Default Find the First of the Month after 60 days

Well you must be reading a different post from me as the OP said

.... If the 60 days falls on the first of the month, then it should produce
the
same number, as in the date given would be 9/2/08 and 60 days would be
11/1/08 and so it should produce 11/1/08.

That seems unequivocally clear to me.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Rick Rothstein (MVP - VB)" wrote in
message ...
Hmm! Good point! I am guessing that is why David posted his code with 59
instead of 60. I know you are right and that has to be what the OP meant
that he wanted; but, just in case, I thought I would mention that on a
close reading of the original posting, my formula does do exactly what the
OP asked for.

Rick


"Bob Phillips" wrote in message
...
You haven't catered for 60 days falling on the 1st of month, you go one
too far then, e.g. 2nd June

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Rick Rothstein (MVP - VB)" wrote
in message ...
You can use this formula...

=DATE(YEAR(F3+60),MONTH(F3+60)+1,1)

Rick


"NeSchw6G" wrote in message
...
I need help making a formula to use the date in cell F3, add 60 days and
then
find the first of the following month.

i.e. The date given would be 8/21/08 and I would need a formula to
produce
11/1/08

If the 60 days falls on the first of the month, then it should produce
the
same number, as in the date given would be 9/2/08 and 60 days would be
11/1/08 and so it should produce 11/1/08.

Thank you,






 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel to make the days cary over month to month automaticly GARY New Users to Excel 1 April 19th 08 06:05 PM
Number of days in month counted from shortened name of month & yea Tumar Excel Worksheet Functions 6 September 18th 07 03:36 PM
Find the number of days in a month catrrmg Excel Worksheet Functions 2 August 1st 07 12:04 PM
Days per month for calculating storage days Bart Excel Worksheet Functions 3 January 31st 07 06:40 PM
function to fill all days of month to end of month YaHootie Excel Worksheet Functions 10 May 1st 06 06:01 AM


All times are GMT +1. The time now is 03:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"