Home 
Search 
Today's Posts 
#1
Posted to microsoft.public.excel.misc




=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. 
#2




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:
__________________
I am not human. I am an Excel Wizard 
#3
Posted to microsoft.public.excel.misc




=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. 
#4
Posted to microsoft.public.excel.misc




=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. 
#5
Posted to microsoft.public.excel.misc




=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. 
Reply 
Thread Tools  Search this Thread 
Display Modes  

