Get instant live expert help on I need help with excel formula first day of month
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I have a monthly spreadsheet broken down day by day. I want the last day of the month on one sheet to connect to the first day of the month on the next sheet so that the data is continuous, but just on different sheets. Many thanks
Solved by C. U. in 21 mins
I need to have all the days in the month change over automatically for a particular month when i enter in the first day of the month
Solved by B. J. in 13 mins
I need a formula for the drive spreadsheet to return the date of the first day of the month and the day from the start of the week.
For example, every month one should be 01-07-2018 then 01-08-2018
The other should change every week 01-07-2018 to 08-07-2018 to 15-07-2018
Solved by O. D. in 21 mins
I have a working formula that looks at 3 different cell values "Year" "Month" "Day"
If "Day" cell = Select, Ignore "day" and show the combined total for "Year" and "Month" and ignore "Day" value
Solved by B. J. in 15 mins
=countifs(J17:J142;>=outil!C4;D17:D142;"open")
This don't work don't know why
outil!C4 is the first day of the month
=eomonth(today();-1)+1
Solved by S. L. in 19 mins