Hi
I have a column stating dates. i would like to have another column with formula to show how many days left till the end of the year from the date stated.
May i know what formula to use?
Thanks
Hi
I have a column stating dates. i would like to have another column with formula to show how many days left till the end of the year from the date stated.
May i know what formula to use?
Thanks
Last edited by Harrold; 11-15-2011 at 02:05 AM.
Assuming date is in cell A1
Please Login or Register to view this content.
@ Harold
after initiating optomyst formula better to format the cells to general or number otherwise it will display dates not the expected remaining Number of Days.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks