I am using the formulae =(EOMONTH(NOW(),0)-NOW())+1 to calculate the days left in the current month including today.
The problem is that before 12h00 the days are calculated correctly but just after 12h00 the days left in the month is one day short.
2007-02-01 07:03:19 · 3 answers · asked by Anton v 1 in Business & Finance ➔ Other - Business & Finance
Use this instead:
=DATE(YEAR( TODAY()), MONTH( TODAY())+1, 1) - TODAY()
And it gives you the number of days
Enjoy my profile, I am the VBAXLMan
2007-02-02 21:43:09 · answer #1 · answered by Anonymous · 0⤊ 1⤋
for a worksheet formula (as opposed to VBA) you should use today() instead of now()
the formula below works fine either before or after 12h00
=EOMONTH(TODAY(),0)-TODAY()+1
2007-02-03 05:42:13 · answer #2 · answered by Anonymous · 0⤊ 0⤋
use the integer int() function. It will chop off the minutes and hours.
2007-02-01 14:10:59 · answer #3 · answered by unnga 6 · 0⤊ 1⤋