Date Projection
 

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 Projection
 

One way:

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

Copy down as needed

--
Biff
Microsoft Excel MVP


"Paul" wrote in message
...
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 Projection
 

Paul wrote:
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)

Date Projection
 

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

Date Projection
 

On Oct 31, 1:16*pm, Paul wrote:
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

Date Projection
 

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

"Paul" wrote:

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 Projection
 

=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


"Spiky" wrote in message
...
On Oct 31, 1:16 pm, Paul wrote:
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

Date Projection
 

On Oct 31, 1:42*pm, "T. Valko" wrote:
=EOMONTH(A1,0)+1

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 ;-)

Date Projection
 

Just curious, is that an error that MS is aware of? 1900 is not a leap year :)
--
** John C **


"T. Valko" wrote:

=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


"Spiky" wrote in message
...
On Oct 31, 1:16 pm, Paul wrote:
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

Date Projection
 

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

"John C" <johnc@stateofdenial wrote in message
...
Just curious, is that an error that MS is aware of? 1900 is not a leap
year :)
--
** John C **


"T. Valko" wrote:

=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


"Spiky" wrote in message
...
On Oct 31, 1:16 pm, Paul wrote:
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

Date Projection
 

WOW!! You're really old!

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


--
Biff
Microsoft Excel MVP


"Spiky" wrote in message
...
On Oct 31, 1:42 pm, "T. Valko" wrote:
=EOMONTH(A1,0)+1

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 ;-)

Date Projection
 

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

"Peo Sjoblom" wrote:

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

"John C" <johnc@stateofdenial wrote in message
...
Just curious, is that an error that MS is aware of? 1900 is not a leap
year :)
--
** John C **


"T. Valko" wrote:

=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


"Spiky" wrote in message
...
On Oct 31, 1:16 pm, Paul wrote:
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

Date Projection
 

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

--


Regards,


Peo Sjoblom

"John C" <johnc@stateofdenial wrote in message
...
Sorry, silly question, I was sure they knew about it, just really
wondering
if they are ever going to fix it...
--
** John C **

"Peo Sjoblom" wrote:

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

"John C" <johnc@stateofdenial wrote in message
...
Just curious, is that an error that MS is aware of? 1900 is not a leap
year :)
--
** John C **


"T. Valko" wrote:

=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


"Spiky" wrote in message
...
On Oct 31, 1:16 pm, Paul wrote:
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

Date Projection
 

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.

--
Thanks,
Shane Devenshire


"John C" wrote:

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

"Peo Sjoblom" wrote:

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

"John C" <johnc@stateofdenial wrote in message
...
Just curious, is that an error that MS is aware of? 1900 is not a leap
year :)
--
** John C **


"T. Valko" wrote:

=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


"Spiky" wrote in message
...
On Oct 31, 1:16 pm, Paul wrote:
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

Date Projection
 

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
:)
--
** John C **


"ShaneDevenshire" wrote:

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.

--
Thanks,
Shane Devenshire


"John C" wrote:

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

"Peo Sjoblom" wrote:

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

"John C" <johnc@stateofdenial wrote in message
...
Just curious, is that an error that MS is aware of? 1900 is not a leap
year :)
--
** John C **


"T. Valko" wrote:

=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


"Spiky" wrote in message
...
On Oct 31, 1:16 pm, Paul wrote:
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