LinkBack URL
About LinkBacks
Hi all,
Does any have /know how i can fix the formula below to
show the number of remaining days between the given date
and the current date.
Where B2 = Now()
=(YEAR($B$2)-YEAR(H18))*31-DAY($B$2)-DAY(H18)
Hi all,
Does any have /know how i can fix the formula below to
show the number of remaining days between the given date
and the current date.
Where B2 = Now()=(YEAR($B$2)-YEAR(H18))*31-DAY($B$2)-DAY(H18)
Last edited by bdb1974; 04-10-2009 at 06:03 PM.
Try
=TODAY()-H18
(and format cell as number with 0 decimal places)
Never use Merged Cells in Excel
If you are counting days then B2 would be better as
=TODAY()
then to calculate the number of days between 2 dates you can just subtract one from the other, i.e.
=H18-$B$2
format result cell as general
Thanks Guys.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks