I need to use the number of calendar days for a 6 month forecast. I have attached a sample file with my calculation. Is there a better alternative formula and how do I calculate the last month?
Thanks in advance
I need to use the number of calendar days for a 6 month forecast. I have attached a sample file with my calculation. Is there a better alternative formula and how do I calculate the last month?
Thanks in advance
=eomonth(b7,0)-eomonth(b6,0)
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thanks for your reply. I can use that formula for all the months except the 1st month. Is the MAX formula OK?
MAX formula is fine but you can also use this if you like.
=EOMONTH(B2,0)-EOMONTH(B2,-1)
bump because my previous post does not appears....
Thank you.
You are welcome and thanks for the feed back.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks