You're very welcome.
Regards,
Ron
Microsoft MVP (Excel)
"hurds999" <hurd...@discussions.microsoft.com> wrote in message news:C1C6B9BB-CF9F-4382...@microsoft.com...
Thank you both very very much. The formula(s) worked!! You're both very awesome!!! Have a great Wednesday, because you've made mine!!! =)
"Ron Coderre" wrote:
If you have the Analysis ToolPak add-in installed:
A2: =EOMONTH(A1,0)+1
If you don't....
A2: =DATE(YEAR(A1),MONTH(A1)+1,0)+1
Does that help?
Post back if you have more questions.
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
"hurds999" <hurd...@discussions.microsoft.com> wrote in message
news:F7183A19-41E6-417E...@microsoft.com...
I have a date in A1, but I need to populate A2 with the first day of the >> > following month. Example: A1 = 05/17/08, A2=06/01/08
What formula would best work to accomplish this? I'm guessing this
would
be
easy, but I can't get anything to work.
Thank you in advance for any assistance.
Hi! I have an almost similar question to this. How can I round up the date in Cell A3 to the nearest weekday? I hope to hear from you. Thank you so much!
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 296 |
Nodes: | 16 (2 / 14) |
Uptime: | 90:11:44 |
Calls: | 6,658 |
Files: | 12,203 |
Messages: | 5,334,090 |