![]() |
=BOMONTH?
Can anyone tell me whether there is a function similar to =EOMONTH to refer
to the beginning of the month instead of the end of the month that the function is referencing? Failing that is there some formula I could use? Many thanks in advance. Andrew. |
Answer: =BOMONTH?
Hi Andrew,
Yes, there is a function similar to =EOMONTH that refers to the beginning of the month. It's called =BOMONTH. Here's how you can use it:
If you prefer to use a formula instead of a function, you can use the following formula to calculate the beginning of the month: Formula:
|
=BOMONTH?
Bloody Brilliant! Thanks!
"Niek Otten" wrote in message ... To get the beginning of this month: =EOMONTH(TODAY(),-1)+1 -- Kind regards, Niek Otten Microsoft MVP - Excel "Andrew Mackenzie" wrote in message ... Can anyone tell me whether there is a function similar to =EOMONTH to refer to the beginning of the month instead of the end of the month that the function is referencing? Failing that is there some formula I could use? Many thanks in advance. Andrew. |
=BOMONTH?
To get the beginning of this month:
=EOMONTH(TODAY(),-1)+1 -- Kind regards, Niek Otten Microsoft MVP - Excel "Andrew Mackenzie" wrote in message ... Can anyone tell me whether there is a function similar to =EOMONTH to refer to the beginning of the month instead of the end of the month that the function is referencing? Failing that is there some formula I could use? Many thanks in advance. Andrew. |
=BOMONTH?
You could also use:
=A1-(DAY(A1)-1) -- ** John C ** "Andrew Mackenzie" wrote: Can anyone tell me whether there is a function similar to =EOMONTH to refer to the beginning of the month instead of the end of the month that the function is referencing? Failing that is there some formula I could use? Many thanks in advance. Andrew. |
All times are GMT +1. The time now is 03:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com