Date Projection

[Paul]

I have 2 columns. In the first column I would have dates and I want the next
column to project teh first day of the upcoming month based on the date in
column A. Anyway way to do that as a function?

Thank you in advance for any assistance.

 

[T. Valko]

One way:

=DATE(YEAR(A1),MONTH(A1)+1,1)

Copy down as needed

 

[Glenn]

I have 2 columns. In the first column I would have dates and I want the next
column to project teh first day of the upcoming month based on the date in
column A. Anyway way to do that as a function?

Thank you in advance for any assistance.

=DATE(YEAR(A1),MONTH(A1)+1,1)

 

[TomPl]

=DATE(YEAR(A5),MONTH(A5)+1,DAY(1))

 

[Spiky]

I have 2 columns.  In the first column I would have dates and I want the next
column to project teh first day of the upcoming month based on the date in
column A.  Anyway way to do that as a function?

Thank you in advance for any assistance.

With Excel 2007 or Analysis Toolpak:

=EOMONTH(A1,0)+1

 

[John C]

Assuming the Analysis Tool-Pak add-in is installed, you could use this formula:
=EOMONTH(A1,0)+1

 

[T. Valko]

=EOMONTH(A1,0)+1

The Op will probably be ok if they use that but try it on this date:

2/11/1900

--
Biff
Microsoft Excel MVP

I have 2 columns. In the first column I would have dates and I want the
next
column to project teh first day of the upcoming month based on the date in
column A. Anyway way to do that as a function?

Thank you in advance for any assistance.

With Excel 2007 or Analysis Toolpak:

=EOMONTH(A1,0)+1

 

[Spiky]

The Op will probably be ok if they use that but try it on this date:

2/11/1900

WOW!! You're really old!

J/K ;-)

 

[John C]

Just curious, is that an error that MS is aware of? 1900 is not a leap year

 

[Peo Sjoblom]

Yes, they copied this intentionally from Lotus 123 where it was a bug.
Of course that was before they became a de facto monopoly and when Lotus 123
was the leading spreadsheet.

--


Regards,


Peo Sjoblom

 

[T. Valko]

WOW!! You're really old!

Not really. I'm just a young punk! <g>


--
Biff
Microsoft Excel MVP

The Op will probably be ok if they use that but try it on this date:

2/11/1900

WOW!! You're really old!

J/K ;-)

 

[John C]

Sorry, silly question, I was sure they knew about it, just really wondering
if they are ever going to fix it...

 

[Peo Sjoblom]

No because it would break the date formulas in too many workbooks
using date calculations.

--


Regards,


Peo Sjoblom

 

[ShaneDevenshire]

Hi,

And this is why there is a 1904 date system option. The Mac version of
Excel did not need to follow 1-2-3 so the stepped around the error.

 

[John C]

Never knew that, thanks for the info . I always thought the 1904 date
system was so as to not get the ######## answers if you have 'negative' dates