Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Projection
=DATE(YEAR(A5),MONTH(A5)+1,DAY(1))
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 ;-) |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 ;-) |
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#14
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#15
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Projection | Excel Discussion (Misc queries) | |||
Projection formula | Excel Discussion (Misc queries) | |||
Rota Projection | Excel Discussion (Misc queries) | |||
Projection of values | Excel Worksheet Functions | |||
dealing with a projection | Charts and Charting in Excel |