Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date function
Sometimes I feel stupid. I've been trying to create a formula for hours and never thought to look for a forum. Is there a way that if I enter a date in say A1 as 5/4/06 that excel will then in A2 subtract that date from the end of it's month to give me the remaining days. But the formula needs to work for all months. So if I enter that date it will go to the month of may and subtract. But, my next date may be 2/4/04. So it need to work with all months. Is this even possible? Thanks for the help and I know I will have a lot more questions for everyone. -- boardmaker ------------------------------------------------------------------------ boardmaker's Profile: http://www.excelforum.com/member.php...o&userid=34854 View this thread: http://www.excelforum.com/showthread...hreadid=546014 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date function in Excel that updates only when a doc is changed? | Excel Worksheet Functions | |||
Date Function | Excel Discussion (Misc queries) | |||
date format and the RIGHT function | Excel Worksheet Functions | |||
Date function | Excel Worksheet Functions | |||
Is there a function to show future date | Excel Worksheet Functions |